Add Zero to single digit numbers

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