Say you have a number like 01234 - a total for five digits.

Format Cells... Number Custom and make it 00000

You will always get the leading zero, even if you only entered 4 digits.
--
Gary's Student


"Sean Timmons" wrote:

This has to be an easy one, but I can't find it. How do I retain the leading
zero in a number and retain number formatting?