Three ways of doing this:

- Format the cell as text before you enter the data.
- Start the number with an apostroph (')
- Create a custom format like 000000,00 which will show the numbers with
alway 6 numbers before the comma.

hth

"C Tate" wrote:

How do I format a cell to show a leading zero?

Thanks in advance.