Forum Discussion
Solved
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,...
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
YES thank you!