Using a Custom Format will give you the appearance of having the leading
zeros, but the real value in the cell will be just the number part. If you
actually want the leading zeros to be in place, you will have to Concatenate
them into place, as any value with leading zeros is seen by Exxcel as TEXT.

Vaya con Dios,
Chuck, CABGx3



"pianogirlny" wrote:

I'm trying to auto fill a list of numbers, but I need the zeros at the
beginning to show in the filled cells.

For example, I type "0001 08" in my first cell. When I drag to auto fill
the next cells, Excel only puts in "2 08, 3 08, etc." I need it to fill with
"0002 08, 0003 08, etc"

I tried customizing the number format of the cells I'm filling, and that
didn't work. Is there a way to do what I'm trying to do?