Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help sorting text as numbers
Is it possible to have a cell display text but have a numeric value?
I am looking to correctly sort publications. Cell values are "January","February", etc. Sorting them puts them in alphabetical order, so I would like the cell to say "January" but when I sort, have it recognized as "1". I'm hoping whatever solution might be available will also help sort a different text field with the same problem. Values would be "45 (1)", "46 (2)", "3", "4", "5", "6", and I would like "45 (1)" to come first. Current sorting puts it at the bottom. Any help would be appreciated. Thx. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help sorting text as numbers
Add a custom list with the months in the correct order... Tools | Options | Custom Lists. After adding the list, you can use it when sorting... Data | Sort | Options (button) | First key sort order (drop down) -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) devproduct wrote in message Is it possible to have a cell display text but have a numeric value? I am looking to correctly sort publications. Cell values are "January","February", etc. Sorting them puts them in alphabetical order, so I would like the cell to say "January" but when I sort, have it recognized as "1". I'm hoping whatever solution might be available will also help sort a different text field with the same problem. Values would be "45 (1)", "46 (2)", "3", "4", "5", "6", and I would like "45 (1)" to come first. Current sorting puts it at the bottom. Any help would be appreciated. Thx. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting cells that have both Text and Numbers | Excel Discussion (Misc queries) | |||
Sorting (Numbers with Text) | Excel Discussion (Misc queries) | |||
sorting a column with numbers and text | Excel Worksheet Functions | |||
Sorting numbers as Text | New Users to Excel | |||
SORTING TEXT AND NUMBERS | Excel Worksheet Functions |