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