How do I resort numerical info into numerical order

  • Thread starter Thread starter Liz M
  • Start date Start date
L

Liz M

excel currently sorting numerical info into numerical/alphabetical order as
1,10,100 etc. instead of 1,2,3 etc. Anyone know how can set to resort as 123?
 
The numbers are probably stored as text. Please make sure you have enabled
the rule 'Number stored as Text' in menu Tools>Error Checking>Options.

--Now you can notice a green triangle in the top-left corner of the cell
with the numeric data
--Select the range and activate one of the cells with numeric data
--To the left of the activated cell you can notice a small exclamation box
popped up. Click on this to drop down and click the option 'Convert to
number'.
--Try and sort the range now..
 
Back
Top