If we try to enter a number like 00009 in our spreadsheet, once we enter it, it becomes just a 9. So annoying!
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!