By default, Excel does not display leading zero in any non-decimal numeric data set. But if you need to show the leading zero, generally due to some strange numbering system in your work, it's easy to keep that zero in place.
In any individual Excel document, select one or more cells (or a whole column or row) and then Ctrl + 1 to open the menu “Cell format”. (MacOS users should use Command + 1 instead).
In the Format Cells window, in the tab “Number”, select entry “Personalized” in the Category list. In the countryside “Guy” right, type zeros that indicate the number of digits you want to display. As an example, if you always want to see four digits, scribe “0000” in the countryside.
You will also have to add decimal places manually. As an example, if you list payments up to $ 500 including pennies, you must specify your custom value as 000,00 to avoid rounding to the nearest dollar.
Formatting changes are applied to the cells you selected. Repeat this procedure as many times as you need on a single sheet or workbook; different cells or groups of cells can use different number formats on the same sheet.
