View Single Post
  #2   Report Post  
Bill Martin -- (Remove NOSPAM from address)
 
Posts: n/a
Default

Uncle Al wrote:
I am sorting a list of numbers containing 100510 and 10160 and 100510 comes
out before 10160 which is out of order. How do I get them to sort properly?

----------------------

Are you sure they are numbers and not text? To check if your "number"
(in A1 for example) is really text, over in an empty cell somewhere put:

[ ]=istext(A1)

That will return either "true" or "false" telling you if it's really text.

To convert the column to numbers, you can highlight all the cells in the
column and then click Format Cells Number. After that, they should
all sort correctly.

Good luck...

Bill