3Answers
How to solve the problem that the values in the excel table are only sorted by the first digit
Asked by: Turner 380 views Software
How to solve the problem that the values in the excel table are only sorted by the first digit
+6Votes
That’s because your data is entered in text format: as shown in the data (text format)
The result of the sort:
is the sort that you said
Solution: Convert it to a number
The result of reordering will satisfy your requirements
+7Votes
The method of netizen [Xiaowugeer] has no change unit The format is very good.
The method of [Galumph_Tom] changed the cell format, and the result is correct. It is also a good way.
+1Votes
When you click [Sort], there will be a prompt:
Note: Possible issues
Check that all data is stored as text If the number contained in the column to be sorted is stored both as a number and as text, you need to set these numbers to a numeric or text format; if you don’t apply this The format, then the number stored as a number will be placed in front of the number stored as text. To set all selected data to text format, press Ctrl+1 to launch the Format Cell dialog box, click the Number tab, and under Categories, click General , “number” or “text”.
Delete any leading spaces In some cases, data imported from other applications may have leading spaces in front of them. Please remove these leading spaces before sorting the data. You can do this manually, or you can use the TRIM function.