How do I get zero to display, ie. 01234
 

Is there a way to display zero as a leading number, ie. 0567

How do I get zero to display, ie. 01234
 

You can use a custom format but it means you have to have a fixed sets of
digits to display

0000

as an example would return 0567 but it would also return 1234 and not 01234




--


Regards,


Peo Sjoblom


"coyot1" wrote in message
...
Is there a way to display zero as a leading number, ie. 0567

How do I get zero to display, ie. 01234
 

Format the cell as text before you enter your data and precede the data
with an apostrophe. ex. '0543 the apostrophe will not show in the cell.
Regards
Cimjet
"coyot1" wrote in message
...
Is there a way to display zero as a leading number, ie. 0567