Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting
When I sort a column of numbers, it comes out like this:
1112 1112 2298 23 5648 889 When I want it to list them from small to big, like this: 23 889 1112 1112 2298 5648 I can understand that the computer thinks the first way is right... but can I fix this? |
#2
|
|||
|
|||
The problem is that the computer thinks the numbers are text.
Place a 1 in a blank cell. Select the cell and Edit/Copy Select the range of numbers and Edit/Past Special and select the Multiply option. That should resolve the problem. PC "Kmarie" wrote in message ... When I sort a column of numbers, it comes out like this: 1112 1112 2298 23 5648 889 When I want it to list them from small to big, like this: 23 889 1112 1112 2298 5648 I can understand that the computer thinks the first way is right... but can I fix this? |
#3
|
|||
|
|||
Thank you!
"PC" wrote: The problem is that the computer thinks the numbers are text. Place a 1 in a blank cell. Select the cell and Edit/Copy Select the range of numbers and Edit/Past Special and select the Multiply option. That should resolve the problem. PC "Kmarie" wrote in message ... When I sort a column of numbers, it comes out like this: 1112 1112 2298 23 5648 889 When I want it to list them from small to big, like this: 23 889 1112 1112 2298 5648 I can understand that the computer thinks the first way is right... but can I fix this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
sorting number in ascending order | Excel Discussion (Misc queries) | |||
SORTING question | New Users to Excel | |||
Adding a KeyID column for sorting | New Users to Excel | |||
sorting question | Excel Discussion (Misc queries) |