
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.
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.