auto fill sequence...
 

I am sure this is simple but cannot figire it out. I don't use Excel
that much but need to create a large table.

I have a list of numbers that I want to sequence as I drag fill
handle.

This is what I want:

190 83 00*1*x
190 83 00*2*x
190 83 00*3*x, etc.

What I get:

19*1 *83 001x
19*2* 83 001x
19*3* 83 001x

How do I get it to ascend the last number ratehr than the first? I went
thru help but am confused. This is just a plain number, not currency,
dates, etc. *Please help!
*
thanks :)


--
tiaj
------------------------------------------------------------------------
tiaj's Profile: http://www.excelforum.com/member.php...o&userid=32792
View this thread: http://www.excelforum.com/showthread...hreadid=526148

auto fill sequence...
 

Hi

Use something like this:
="190 83 00"&ROW()-1&"x"
You may need to use ROW()-2, or -3 to get the correct starting figure.

Andy.

"tiaj" wrote in message
...

I am sure this is simple but cannot figire it out. I don't use Excel
that much but need to create a large table.

I have a list of numbers that I want to sequence as I drag fill
handle.

This is what I want:

190 83 00*1*x
190 83 00*2*x
190 83 00*3*x, etc.

What I get:

19*1 *83 001x
19*2* 83 001x
19*3* 83 001x

How do I get it to ascend the last number ratehr than the first? I went
thru help but am confused. This is just a plain number, not currency,
dates, etc. *Please help!
*
thanks :)


--
tiaj
------------------------------------------------------------------------
tiaj's Profile:
http://www.excelforum.com/member.php...o&userid=32792
View this thread: http://www.excelforum.com/showthread...hreadid=526148

auto fill sequence...
 

worked like a charm! I knew it was easy :)

thank you!!


--
tiaj
------------------------------------------------------------------------
tiaj's Profile: http://www.excelforum.com/member.php...o&userid=32792
View this thread: http://www.excelforum.com/showthread...hreadid=526148

auto fill sequence...
 

Glad to help and thanks for the feedback!

Andy.

"tiaj" wrote in message
...

worked like a charm! I knew it was easy :)

thank you!!


--
tiaj
------------------------------------------------------------------------
tiaj's Profile:
http://www.excelforum.com/member.php...o&userid=32792
View this thread: http://www.excelforum.com/showthread...hreadid=526148