Forum Discussion
Excel Sorting Weird
I've noticed recently that Excel will sort my rooms not exactly in order. I'm sure it has something to do with how we label rooms in our system. Is there anything I can do to make it sort correctly?...
103 is a number but 103-A is text. Excel sorts number before text.
You might format the cells as text before entering the room numbers, or prefix the values with an apostrophe '.
But you'd also have to enter a room number such as 10 or 10A or 10-A as 010, 010A and 010-A.