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
>
Bookmarks