Microsoft Excel 2007

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.

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

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.

Thanks for your time guys. It has helped me out alot. That fill handle will save me heaps of time. :)

Ask Your Question

Weekly Poll

Do you think Google Fiber has a strong future?

Discuss in The Lounge

Poll History