Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel will not sort column
I have copied columns from one excel sheet to another and when i go to sort
my one column that i moved it will not sort. All other columns that were there originally will sort but not the numbers that i moved. Any ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel will not sort column
Whether the data is text or numbers, it should sort. Maybe, what you think
you are looking at is not actually what you are looking at. Try to find out what kind of data you are working with: =ISNUMBER(A1) will show you whether the data is numeric or something else =ISTEXT(A2) will show you whether the data is text or something else =TRIM(A3) will delete any spaces in front of your data Hope some of this helps. Regards, Ryan--- -- RyGuy "Steve" wrote: I have copied columns from one excel sheet to another and when i go to sort my one column that i moved it will not sort. All other columns that were there originally will sort but not the numbers that i moved. Any ideas? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel will not sort column
Well, which did you do - copy the column, or move it? Was it a complete
column, or a range of cells? Did you insert it, or paste into an existing column/range? If the latter, how were the cells formatted before pasting? How are the cells formatted now? Do you have formulas in the cells, or values? When you say "will not sort", what happens - nothing at all, or it sorts in an unexpected order? "Steve" wrote in message ... I have copied columns from one excel sheet to another and when i go to sort my one column that i moved it will not sort. All other columns that were there originally will sort but not the numbers that i moved. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to fix if Excel won't sort a column? | Excel Discussion (Misc queries) | |||
data, sort option is grayed. how to sort on a column? | Excel Discussion (Misc queries) | |||
Last column in Excel does not sort | Excel Discussion (Misc queries) | |||
Sort Excel Column on Fifth Character | Excel Worksheet Functions | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |