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

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


"Phil Wales" wrote:

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

Phil Wales wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200803/1

Phil Wales wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200803/1

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

"Phil Wales" wrote:

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