LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default sort issue: Excel seems to be treating my column of numbers"alphabetically"

Hi All,

I am trying to sort a column of numbers in numerical order. When I
attempt to do this excel seems to want to sort them as though they
were letters. Here is an example:
1*
10032*
10044*
10071*
10107*
10175*
102164*
10306*
10353*
10394*
10421*
1044*
1045*
10471*
10670*
10683*
10730*
10759*
10769*
10795*
1081*
10853*
10875*
10877*
110800*
11137*
11246*
113366*
11385*
1142*
11480*
11524*
11563*
1165*
117*
12062*

I have checked that it is formatted as a number and not text. I have
no idea how to make excel sort them in numerical order.

Any thoughts?

Cheers,

D
 
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
sort 2 column in the same time "" as dictionary "" Mahmoud Mustafa Excel Worksheet Functions 0 May 1st 10 01:53 PM
Sort "text" numbers with and without leading zeros as numbers T.K. Excel Discussion (Misc queries) 1 February 10th 08 04:19 PM
My Column display as "numbers" instead of "alphabets" ali Excel Discussion (Misc queries) 1 October 24th 07 05:16 AM
Can Excel "extract" ranges of numbers listed in the A column? Quco Excel Programming 6 July 19th 07 01:40 PM
Can Excel "extract" ranges of numbers listed in the A column? Quco Excel Discussion (Misc queries) 7 July 9th 07 01:58 PM


All times are GMT +1. The time now is 07:03 AM.

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"