fill down, job numbers

Microsoft Excel 2007
July 2, 2009 at 05:43:34
Specs: Windows Vista, 2GB
Can anyone tell me how to enter 01/001 in a cell and fill down so that the next will be 01/002 and so on. Need help otherwide I need to type it out hundreds of time.

See More: fill down, job numbers

Report •

July 2, 2009 at 06:23:26
Type in the first two rows 01/001 and 01/002

Then highlight the two cells you've typed into, and use the little fill handle (bottom right corner of the selection) to drag it down. Excel should recognise the sequence, though you'll have to do this again with 02/001...etc

Report •

July 2, 2009 at 07:08:08
My Excel 2003 does it with just 01/001 in the first cell. Excel assumes you want to increment the last number. That works for most things,

e.g. Item 1, Item1, Item 10, etc.

Just for fun, you can also do things like:

In Row 1: ="01/00" & ROW() which will replace ROW() with the row number for whatever Row the formula is in.

In Row 10: ="01/00" & ROW()-9 which will also give you 01/001 'cuz 10 - 9 = 1.

Report •

July 2, 2009 at 07:19:59
Thanks for your time guys. It has helped me out alot. That fill handle will save me heaps of time. :)

Report •

Related Solutions

Ask Question