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.
Stay Healthy. Stay Informed. Find updates and resources about the Novel Coronavirus.
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.
