How do I format a cell to show a leading zero? Thanks in advance.
H hans bal(nl) Jun 21, 2006 #4 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
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
