How to Make '1' appear as '01'

[Phil Wales]

Is there a way when entering a figure like

1

appear as 01 in a cell i.e. add a 0 to it at the front ?

thanks

 

[WLMPilot]

Click on cell to format. Goto FORMAT > CELLS. Click on the "Number" tab and
choose CUSTOM. In the section for Type, put "0#" (without quotes)


Les

 

[Francois via OfficeKB.com]

Is there a way when entering a figure like

1

appear as 01 in a cell i.e. add a 0 to it at the front ?

thanks

Format Cell, Custom, 00

 

[Francois via OfficeKB.com]

Is there a way when entering a figure like

1

appear as 01 in a cell i.e. add a 0 to it at the front ?

thanks

Format Cell, Custom, 00

 

[FSt1]

hi
another way.
preformat the cell as text.
or preceed the input with an apostrophe ie '01
a custom format will do the job but also understand that formats do not
change data, they only change the way data looks in the cell. if you were to
try and export a number formated as 01, all that would export would be the
number 1. formated as text, the export would be 01.

Regards
FSt1