How to Keep Leading Zeros in Excel | Automatically Keep Zero In Front of Number

In this Microsoft Excel video tutorial I explain how to keep zeros in front of a number. Excel has always, by default, removed leading zeros. Now we have the option to turn this data conversion feature off.

#exceltutorial #exceltips #excel365 #exceltricks

[konnie]

Leading zeros have been a big pain for me as handling user created identifiers. What sick person came up with starting identifiers with zeros? I have been doing the two workarounds you mentioned for ages, so I am grateful that you showed the new option for 365. Thank you!

[Jojosmith]

all thumbs up to the best excel teacher Chester. Thank you Chester for another valuable tutorials

[mclarissa]

I'm at work and you just saved my tuchus

[Deem]

How do you do this method on an apple IPAD

[sahyanmskah]

How to remove decimal between number for example
01.01 I want to change it to 0101
Please help

[Ian-wvej]

Hi, this doesn't work in CSV files is that right? because i need to keep my file type as a CSV for an upload and i cant get them to stay