A10 sorting before A1

A10 sorting before A1

ArcnailArcnail Posts: 2Questions: 0Answers: 0

Sorry, if this has already been answered, searched for about an hour and couldn't find anything.

Basically I have a list of table rows that I would like to sort. Ultimately what happens is this..

A10:Program Name
A11:Program Name
A1:Program Name
A2:Program Name
A3:Program Name
...
A7:Program Name
A8:Program Name
A9:Program Name

I figured just putting a 0 in front of the single digit as such 'A01' would solve it, but it doesn't.

Any insight as to what I'm doing wrong here. I'm new to this (clearly ;).

Thanks.

Replies

This discussion has been closed.