Institutional Closing

alert icon BCTC campuses and offices will be closed starting on December 16, 2017. We will reopen on Tuesday, January 2, 2018 with normal operating hours. Have a wonderful holiday and a great new year!

How to Convert Student IDs to digits in Excel

Here is the formula for converting emplids to 9 digits. Place this formula in a separate column.

=TEXT(A1,"000000000")

Change A1 to the column containing the ID without leading zeros.