you can try just going to format cells, click custom at the bottom of the list
click on 0, then enter 00, click ok and format the cells


--


Gary


"user" wrote in message
...
have sheet with 7 columns of numbers. need to format so numbers 1 thru 9 have
a 0 put in front. 01, 02, 03.....

any help?