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?