Displaying a Zero

C

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.
 
B

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)
 
D

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.
 
Top