Forum Discussion
Why is Excel treating text as numbers?
Fsim Since you say you can't edit the values, I assume they come from some kind of import. If so, where from? Upon importing data from e.g. a txt or csv file you need to explicitly indicate the data type of the columns that get imported.
Try this. Select the ID column. On the data ribbon, select Text-to-columns. Advance to step 3 changing nothing. In step 3, set the column data format to Text and press Finish. That should solve the problem.
What are we talking about here? If I use the Excel 365 function SORT to create a sorted list it creates an alphabetic sort if the input is formatted as text (with a little green warning in the top left of the cell warning of numbers formatted as text).
If required, it is even possible so sort numbers alphabetically using
= SORTBY(numbers, TEXT(numbers, "General"))
If, however, we are talking about interactive use of the SORT ribbon command then one has a choice of sort strategy
- Hello Peter, I was talking about the interactive sorting indeed. and I do not have this warning. Only sort from the smalest to the larget. Hopefully the solution from Riny worked .
thanks anyway !
