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 , ...
KerrilynnAZ Thats how I ended up solving the problem for me :) Copying data indeed somehow created characters that I couldn't see, but with the =CLEAN function and the steps you described I could sort them correctly.
DLans YOU just made my day! ;-) It makes it worthwhile when you can share knowledge that someone else finds of benefit - especially in these scenario's. I hate wasting time trying to figure out problems that I can't find quick answers to in order to keep me moving forward, LOL. Thank You!