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 ToolsError CheckingOptions.

--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..




--
Jacob (MVP - Excel)


"Liz M" wrote:

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?