sorting problem

S

susan0713

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!
 
D

David Biddulph

One possibility is that some of your entries may be text and some numbers?
Check with ISTEXT() and ISNUMBER().

Also, if you have two columns, are you sorting by both columns, and if so,
in what priority order, and what are the corresponding entries in the other
column if that is influencing the sorting?
 
P

Peo Sjoblom

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