View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default FORMULA Sorts neg numbers as positive..

What are your sort parameters? If you were sorting Z-A instead of A-Z
then the sort you've listed is working correctly. Bear in mind that
textual representations of numbers is going to sort differently than
the numbers themselves.

Dave O
Eschew obfuscation