ExcelBanter - Data Sort

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Data Sort (https://www.excelbanter.com/excel-discussion-misc-queries/79254-data-sort.html)

LostNFound

Data Sort

I have a column of four digit numbers about 135 different numbers and when I
sort there is some at the bottom that do not go where they belong??

OR-8

Data Sort

Are any of them text?
Check for ' ^ or" at the beginning and also check the format of the cells.

--
Use F1 for Help....
Then ask a friend to decipher it...

"LostNFound" wrote:

I have a column of four digit numbers about 135 different numbers and when I
sort there is some at the bottom that do not go where they belong??

All times are GMT +1. The time now is 02:38 PM.