Add leading zeros to your number

If we try to enter a number like 00009 in our spreadsheet, once we enter it, it becomes just a 9. So annoying!
adding a 3 digit number
adding a 3 digit number

Don’t worry there is a workaround.
Select the whole column by right clicking the top header >> Format Cells > Custom
Under the field for type give as much zeros you need (the number of digits you need)
click Ok and you are done  😃
 
Now you see leading zeros before yournumber. Hurray!

3 digits added in excel

Leave a Reply

Your email address will not be published. Required fields are marked *