Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
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.
Name: jon_k Date: July 2, 2009 at 06:23:26 Pacific
Reply:
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
0
Response Number 2
Name: DerbyDad03 Date: July 2, 2009 at 07:08:08 Pacific
Reply:
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.
0
Response Number 3
Name: Webbba Date: July 2, 2009 at 07:19:59 Pacific
Reply:
Thanks for your time guys. It has helped me out alot. That fill handle will save me heaps of time. :)
Summary: does anyone know a way to fill down to a certain cell w/o dragging. situation: i am in cell a27 and i want to fill a formula that adds .01 to the previous cell all the way down to cell a1027....... ...
Summary: It sounds like wanting to have rownumbers in the A-column, only when B-column is filled, use: =if(B2<>"";A1+1;"") (Copy it in A2 and fill down like Bryan described) A1 should be empty, B1 for the ...
Summary: Here's an example I'd use to see if I'm correct with what you are asking: A B C D E Total Name2 43 27 48 100 Name3 45 30 41 88 Name4 etc. etc. etc. ...
0 
