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),””)))
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),””))) Read More
