How do I resort numerical info into numerical order
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? |
How do I resort numerical info into numerical order
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? |
All times are GMT +1. The time now is 04:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com