LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
TelcordiaJack
 
Posts: n/a
Default Excel 2003 can't do case sensitive sorting!

Contrary to the documentation, sorting an alpha column containing: Cat, dog,
apple,
and Aardvark (with the case sensitive option selected) results in: Aardvark,
apple, Cat, dog. With a case sensitive (ASCII colating sequence) sort, the
results should be: Aardvark, Cat, apple, dog. FWIW, I notice that this
problem has been reported in newsgroups in the past.
 
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
Displays the number in text. (One thousand two hundred thirty four Ashish Patel Excel Worksheet Functions 1 March 20th 06 09:27 PM
Currency to Text mytipi Excel Worksheet Functions 1 February 21st 06 11:43 PM
VBA Monty Excel Worksheet Functions 2 January 30th 06 01:37 PM
Loop for VBA code? paulinoluciano Excel Worksheet Functions 5 December 28th 05 01:30 PM
Spellnumber Norman Jones Excel Worksheet Functions 6 December 13th 04 07:21 AM


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