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 , ...
Nope, in my case it works as expected. Are your numbers are integers in Excel, or that texts? Did you generate them manually (e.g. fill series) or copy/pasted from Web for example?
- They are copy and pasted all from the same site. Chunks of the numbers will sort correctly but then further down they stop sorting right.
If they are not generated within Excel but copy/pasted from the Web, most probably you have non-printable characters inside your cells with numbers. That doesn't matter you used same site or not.
You may check by LEN() applied to cells if all of them returns 4.
If not you may apply =CLEAN(A1)*1 to such cells to remove non-printable characters.
SergeiBaklan, can you explain in detail how to do this, how do I apply this, where do i type it, find it, etc.
