LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tiaj
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto fill option Thana New Users to Excel 2 March 9th 06 06:13 PM
Macro for Auto Fill carolini Excel Discussion (Misc queries) 2 December 6th 05 09:11 PM
Does Excel support Auto fill on filtered data? Maria Excel Discussion (Misc queries) 1 August 26th 05 01:45 PM
Auto Fill Options adarling Excel Discussion (Misc queries) 1 April 8th 05 03:09 AM
Auto Fill Options Patti B Excel Discussion (Misc queries) 3 December 9th 04 12:49 AM


All times are GMT +1. The time now is 04:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"