Hints and tips home » Excel hints and tips » Formst Excel to display leading zeroes

Formst Excel to display leading zeroes

Select the cells that you want to have displaying leading zeroes.

From the 'Format' menu select 'Cells' (Or Right-click on the selected range and and select 'Format Cells').

In the 'Number' tab click on 'Custom' in the 'Category' window.

In the 'Type:' box enter zeroes that correspond to the size of the required number (eg 5 zeroes).

Click OK.

When you enter numbers into these cells, leading zeroes will be displayed.

eg 123 = 00123

Added by Carlos on 21st September 2006

More Excel hints and tips, like:

• Quickly copy a formula across sheets
• date and time
• Using an equal (=) sign that isn't part of a formula