Learn how to add leading zeros on your numeric value in Excel. br I will also be answering the following questions in this video. br How do you keep the 0 in front of a number in Excel? br How do I show 001 in Excel? br How do you prevent Excel from removing leading trailing zeros in a cell? br How do I keep 0 in front of a number in Excel CSV? br br br Here are the steps outline in my video. br br General Format br 1) '000123 br 2) Click on warning icon br 3) Ignore error br br Custom Format br 1) Ctrl + 1 br 2) Number tab br 3) Custom br 4) 000000 br br How do you keep the 0 in front of a number in Excel?,How do I show 001 in Excel?,How do you prevent Excel from removing leading trailing zeros in a cell?,How do I keep 0 in front of a number in Excel CSV?, br br Check out my complete suite of Microsoft Excel Tips and Tricks.