Forum Discussion
Excel not sorting numbers correctly - smallest to largest etc.
I have been helping a friend organize a excel file with 4 digit numbers. These numbers are in the 6000 to 8000 range. When I filter or sort the numbers from smallest to largest there are numbers , ...
SergeiBaklan Thank you, the =CLEAN function helped me out immensely. I cannot see any difference between the input and the output, but the output I can sort properly. Thanks again!
DLans , so far so good, you are welcome. You could see the difference if check =LEN(A1) and =LEN(CLEAN(A1)) if in A1 is initial value