LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
m m is offline
external usenet poster
 
Posts: 64
Default number digits 1-6 not sorting properly

I have a list w/ numbers, dates and description; attempting to sort the list
in number order but it is not recognizing the difference between e.g., 1400
and 14000 or 1623 and 16233 so it's sorty them together. Any help would be
appreciated. I've changed the format to number, text but still not correct
results.
 
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
How to customize number to 10 digits including 2 digits after deci Carina Excel Worksheet Functions 3 September 20th 07 02:50 AM
Sorting in an Excel Chart won't work properly [email protected] Excel Discussion (Misc queries) 1 January 8th 07 08:09 PM
sorting numbers with an irregular number of digits hearthd Excel Discussion (Misc queries) 5 October 8th 06 06:42 PM
How?-Sorting last digits and not the first [email protected] Excel Discussion (Misc queries) 5 July 17th 06 03:47 PM
Sorting data by last to digits Brian Excel Worksheet Functions 2 February 23rd 05 05:44 PM


All times are GMT +1. The time now is 07:21 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"