Zeros in excel
 

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

Thanks in advance.

Zeros in excel
 

Format as text.

"C Tate" wrote:

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

Thanks in advance.

Zeros in excel
 

FormatCellNumber customized: \0#

HTH
--
AP

"C Tate" a écrit dans le message de
news: ...
How do I format a cell to show a leading zero?

Thanks in advance.

Zeros in excel
 

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.