User Profile
cspainhower
Copper Contributor
Joined 5 months ago
User Widgets
Recent Discussions
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),"")))
