Ask Your Question
0

Why won't a column of numbers sort in numerical order in a calc spreadsheet?

asked 2015-06-25 08:51:46 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I have 243 names in column A with corresponding ID numbers in column B. I sort on column A (name). I then copy A and B and paste them into D and E, so I can sort on E and wind up with a reverse lookup list. When I sort on E (ID number), the sort winds up not in numerical order.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2015-06-25 11:46:15 +0100

Alex Kemp gravatar image

One obvious check: are your ID numbers actually saved as integers, or are they saved as strings? From your report it is the latter & karolus's answer will be the way to fix it in the short term.

edit flag offensive delete link more
0

answered 2015-06-25 09:54:37 +0100

karolus gravatar image

try additional Option [x]natural Sort on →Data→Sort....

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-06-25 08:51:46 +0100

Seen: 4,033 times

Last updated: Jun 25 '15