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.