| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
| Store numbers starting with zero as 2 digit numbers | Excel Discussion (Misc queries) | |||
| how can i move the starting point for the numbers numbers down. | Setting up and Configuration of Excel | |||
| I Need a Formula to Auto-fill Phone Numbers in a Range | Excel Worksheet Functions | |||
| How do I get auto fill to do decending numbers in a column? | Excel Discussion (Misc queries) | |||
Threaded Mode
