View Single Post
  #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.