| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting in Excel
I have a list of various numbers and text that I want to sort numerically. Here is an example:
T300 D9745 P50 565 007 0245 052 Problems: 1.Getting leading zeros to show AND be recognized. 2. Sorting--when I try to sort, it will sort like 7,52, 245, 565, P50, T300, D9745. I want it to sort numerically first (007,0245,052,565) then alphabetically (D9745,P50, T300). I'm assuming this is impossible, but any tips would be appreciated. Submitted via EggHeadCafe - Software Developer Portal of Choice Break the Roles in SharePoint Lists http://www.eggheadcafe.com/tutorials...in-sharep.aspx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Values Without Sorting Formulas | Excel Discussion (Misc queries) | |||
| sorting in excel | Excel Discussion (Misc queries) | |||
| Automatic sorting (giving max and min) based on custom sorting lis | Excel Worksheet Functions | |||
| Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
| sorting with excel | New Users to Excel | |||
Threaded Mode
