How do I get zero to display, ie. 01234

[coyot1]

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

 

[Peo Sjoblom]

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

 

[Cimjet]

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