in B1:

=TEXT(A1,"00")

where A1=1 etc

HTH

"MikeD1224" wrote:

I need to be able to do the following:

I have a list of store #'s in column D (ex below). I need to format the
column as text and for any number that is less than 10, I need it to be
changed so that it has a leading 0 that will stay when saved as a CSV file.

I'm stuck on this so any help would be great. Thanks

Current How I want it

1 01
2 02
3 03
4 04
5 05
6 06
7 07
8 08
9 09
10 10