Sorted - problem with decimal

[learning_codes]

Hi,

I have 900 records. I sorted Column A and B (ascending order) but
there are few records from 900 records that have like this below.
This should have sorted by Column A (ascending) and Column B
(descending) but I sorted by ascending order both columns. I hate to
look each records to make sure.


Column A Column B
9303 9303.21 - this should be 3rd row
9303 9302.64 - this should be 1st row
9303 9302.78 - this should be 2nd row

I would be much appreciated for your help.

Thanks

 

[PCLIVE]

According to your explanation of A ascending and B descending, the out put
would be the opposite of what you are saying the result should be.

Meaning,

9303 9303.21
9303 9302.78
9303 9302.64


In either case, neither result is what you are getting. Make sure that
column A is not somehow being rounded. You may want to check the same with
column B. Maybe some cells are being rounded and others are not.

HTH,
Paul

 

[PCLIVE]

One more thing. Check to see if those cells are formatted as numbers and
have no preceeding or trailing spaces.

HTH,
Paul