Displaying a Zero

  • Thread starter Thread starter ceblaser
  • Start date Start date
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.
 
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)
 
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.
 
Back
Top