Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I rarely use Excel, but I need to sort a spreadsheet in which one of the
columns has only numbers. For example: 121.593, 121.58, 121.641, 121.61. My expectation was that Sort Ascending would produce 121.58, 121.61, 121.593, 121.641. Instead, the sort produces the following sequence: 121.58, 121.593, 121.61, 121.641. In other words, it doesn't seem to understand that the two-digit numbers (after the point (.)) go before the three digit numbers. Is there a workaround? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF formula doesn't work with certain numbers | Excel Worksheet Functions | |||
sorting numbers | Excel Discussion (Misc queries) | |||
Sorting formatted numbers | Excel Discussion (Misc queries) | |||
How can I work with more than 15 numbers | Excel Discussion (Misc queries) | |||
Sorting imported "numbers" | Excel Discussion (Misc queries) |