Add Zero to single digit numbers

[vin1602]

Hi. I would like to be able to add a zero to all SINGLE digit numbers in a column, not double digit numbers (for the purpose of Sorting chronologically). Anyone help please?? Thanks.

[Pepe Le Mokko]

Hi
custom format as 00

[Pete_UK]

Use this:

=IF(A1<10,"0,"")&A1

or this if you numbers are already text values:

=IF(LEN(A1)=1,"0","")&A1

then copy down.

Hope this helps.

Pete

[vin1602]

great - many thanks