Displaying a Zero

[ceblaser]

Is there a way that I can force Excel to display a the zero if it is the
first number in a sequence?

For example, if I enter the number 012345 Excel automatically drops the
zero. However, I need this number to appear as 012345 instead of 12345
within the cell.


Thanks.

 

[Bob Phillips]

Format the cell as 000000

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Ken Wright]

Select whole range and do - Format / Cells / Custom - 00000

 

[drabbacs]

Another method is to preceed the data entry with an
apostrophe. '012345 Note however, that this will
cause the cell to be treated as text.