Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Decimals as Numbers
I have a spreadsheet that has a unique identifier field containing eight
digit numbers separated by decimals. Each subset references a specific field on another sheet. I would like to sort by this identifier, but when I do, my decimals sort improperly (for my current need). They sort in the following order: 1.1.1.1.1.1.1.1 1.1.1.1.1.1.1.10 1.1.1.1.1.1.1.2 I would like them to sort numerically by the last number. Is there a way to do this, or an easier way to format this field? Thanks for the help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Decimals as Numbers
You can use Text to Columns on the Data menu to separate the numbers into individual cells. Sort and then remove the added data. Note: make a copy of the column before using Text to Columns. A commercial alternative, from yours truly, can be found here... http://www.officeletter.com/blink/specialsort.html -- Jim Cone San Francisco, USA "NathanP1" wrote in message I have a spreadsheet that has a unique identifier field containing eight digit numbers separated by decimals. Each subset references a specific field on another sheet. I would like to sort by this identifier, but when I do, my decimals sort improperly (for my current need). They sort in the following order: 1.1.1.1.1.1.1.1 1.1.1.1.1.1.1.10 1.1.1.1.1.1.1.2 I would like them to sort numerically by the last number. Is there a way to do this, or an easier way to format this field? Thanks for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting numbers as Text | New Users to Excel | |||
sorting numbers in a column | New Users to Excel | |||
Sorting Numbers with Multiple Decimals | Excel Discussion (Misc queries) | |||
Sorting numbers and text separately | Excel Discussion (Misc queries) | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) |