Prev: copy rows to another file
Next: Ref in two worksheets
From: Liz M Liz on 19 May 2010 06:51
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?
From: Jacob Skaria on 19 May 2010 07:09
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..




--
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?
 | 
Pages: 1
Prev: copy rows to another file
Next: Ref in two worksheets