Thread: sorting problem
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default sorting problem

It's text that's why. You can copy an empty cell, select the cells with the
000 and do editpaste special and select add, then use a custom format of
000

--
Regards,

Peo Sjoblom


wrote in message
ups.com...
I am sorting a two columns of three digit numbers. In the second
column, 000 is sorting after 999. Anybody know what I'm doing wrong?
Thanks!