Forum Discussion
cspainhower
Jul 23, 2024Copper Contributor
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),"")))
Does the following work:
Change the formula to
=SUBSTITUTE(SUBSTITUTE(C2, CHAR(160), ""), " ", "")+0
Does the following work:
Change the formula to
=SUBSTITUTE(SUBSTITUTE(C2, CHAR(160), ""), " ", "")+0
- cspainhowerCopper ContributorYES thank you!