SORTING 1,1A,2,3,4A
 

I thought I knew how this works, but it's not responding like I thought.

The column that I have the data in is formatted at text.

But when I sort, it gives me:
1
2
3
1A
4A

I thought if the entire column is text, then it should sort in dictionary
order. Am I wrong?

SORTING 1,1A,2,3,4A
 

It's not enough for the format to be text. The values in the cells have to be
text, too.

So if you entered 1 (as a number), then changed the format to text, you'll have
to reenter the value.

And in newer versions of excel, there's a choice offered to you to sort anything
that looks like a number as a number. Make sure you don't choose that.

Tboy wrote:

I thought I knew how this works, but it's not responding like I thought.

The column that I have the data in is formatted at text.

But when I sort, it gives me:
1
2
3
1A
4A

I thought if the entire column is text, then it should sort in dictionary
order. Am I wrong?

--

Dave Peterson