Sorting data - number/text problem

Question

I changed formats of all cells in a column to a Text, but it stays sorted as number :( How to sort it as a text, please?

Example:

78
175
205
493
515
582
1171

sorted as numbers, although format is Text

Answer 1

Hi Procházka,

Thanks for getting back to us. 

As you already have input the raw data formatted as Number, we would like to suggest using helper columns. Please insert a column near the current column you would like to sort alphabetically, pick the first cell and input for example =TEXT(A3, "###"), drag down to the bottom of the entire column, then sort A to Z, and select Expand the selection in the below window.

For more detailed information, please check the below article:

How To Sort Alphanumeric Data In Excel?

Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.​​

Let us know if you need further assistance.

Thanks,

Tina

Answer 2

Nah, those are  Czech letters. I have Czech localization. How is the TEXT function localized into Czech, please?

Answer 3

Hi Procházka Miloš,

The TEXT function does have a localization difference, I see the letters in your name are Spanish, this is the TEXT function description in Spanish: TEXTO (función TEXTO). It actually spells as TEXTO in Spanish.

If Spanish is not the language you need, I would love to recommend to you other languages of the same function in Excel. Just post back if you need.

Regards,

Alex

Answer 4

Actually, my exel doesnt offer function =TEXT. I guess thats because of localization of function keywords, there is some wacky translation that Im unable to find...

Answer 5

Thanks for advice. I believe that in older versions if cells were formatted as text, they sorted as a text. I wonder if this change actually helped someone...