View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pianogirlny pianogirlny is offline
external usenet poster
 
Posts: 2
Default Auto fill numbers starting with zero

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?