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 001x
190 83 002x
190 83 003x, etc.

What I get:

191 83 001x
192 83 001x
193 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

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" <tiaj.256n4c_1143218120.5765@excelforum-nospam.com> wrote in message
news:tiaj.256n4c_1143218120.5765@excelforum-nospam.com...
>
> 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
>

worked like a charm! I knew it was easy

thank you!!

Glad to help and thanks for the feedback!

Andy.

"tiaj" <tiaj.256o1n_1143219302.5267@excelforum-nospam.com> wrote in message
news:tiaj.256o1n_1143219302.5267@excelforum-nospam.com...
>
> 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
>