Forum Discussion

cspainhower's avatar
cspainhower
Copper Contributor
Jul 23, 2024

Excel not sorting numbers correctly

I have what I hope is a simple problem - all that I need is for excel to sort numbers numerically. Instead, it is sorting them 1, 10, 11 ... 19, 2, 20, etc.

I've tried pasting my raw data as values, I've tried converting to number, I've tried =CLEAN, =TRIM, =SUBSTITUTE, I've tried pasting just the numbers as values, none of it is working. When I do =ISNUMBER, it keeps coming back false no matter what I try.

My function for Stop (clean) is =CLEAN(TRIM(SUBSTITUTE(C2,CHAR(160),"")))

 

Resources