| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making Lists of numbers
In A1 enter '0001
In A2 enter '0002 Note the leading apostrophe. Type A1:A3000 in NameBox and Hit ENTER. EditFillSeriesAutofill Gord Dibben MS Excel MVP On Fri, 9 May 2008 13:33:02 -0700, nebula wrote: Hello I need to fill Column aye with the numbers 0001-3000 obviously it will make me very unhappy if i have to type each number in the field. is there any way that excel just fills in the rest of the values? (and leaves the extra zeroes on the front?) thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with making a function to filter lists | Excel Worksheet Functions | |||
| Making multiple selections from Excel drop down lists | Excel Worksheet Functions | |||
| Making individualized word lists from a SS | Excel Discussion (Misc queries) | |||
| making a list of numbers. | Excel Discussion (Misc queries) | |||
| making one material list from mulitple vendor material lists | Excel Worksheet Functions | |||
Hybrid Mode
