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.
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.
Hi
custom format as 00
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
great - many thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks