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? |
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? |
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? |
All times are GMT +1. The time now is 06:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com