Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
numbers in a column are not sorting ascending
I am working in an Excel 2007 spreadsheet and one very long column of normal
numbers are not sorting. for Example: 407 408 102 103 104 Everytime I try to sort this ascending, it does nothing. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
numbers in a column are not sorting ascending
Hi,
Try this in another column enter =Trim(A1) I assume column A is where you have that numbers, then copy as value on top of the others an sort it "slhiaz" wrote: I am working in an Excel 2007 spreadsheet and one very long column of normal numbers are not sorting. for Example: 407 408 102 103 104 Everytime I try to sort this ascending, it does nothing. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
numbers in a column are not sorting ascending
slhiaz wrote:
I am working in an Excel 2007 spreadsheet and one very long column of normal numbers are not sorting. for Example: 407 408 102 103 104 Everytime I try to sort this ascending, it does nothing. Are these "actual" examples, or just something that was easy to type? Are they not sorting at all, or not sorting the way you expect them to? It's possible that you have text that looks like numbers. They would sort like this: 1 11 111 12 122 13 133 14 144 2 3 4 instead of like this: 1 2 3 4 11 12 13 14 111 122 133 144 To convert your data to actual numbers, you can enter the number 1 in a blank cell, copy it, select all of your data, then Edit / Paste Special / Values / Multiply / OK. Then try sorting again. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ascending sort definition [sorting alphabetically] | Excel Discussion (Misc queries) | |||
getting numbers divisible by 4 from random numbers in ascending order | Excel Worksheet Functions | |||
ascending sorting | Excel Worksheet Functions | |||
Sorting Data in ascending order | Excel Discussion (Misc queries) | |||
sorting number in ascending order | Excel Discussion (Misc queries) |