If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sorting Problem
I have a large (800 rows X 20 columns) data sheet that I am trying to sort by
numbers in column C. These numbers are from 7 to 9 digits in length. When I try to sort the sheet, Excel uses the left-most digit in this column across to right to sort. Nine digit no.'s beginning with 1 end up at the top and further down 7 digit numbers beginning with a 6 are included. When I recieved this data sheet this column was labled as General and I tried to change it to number. Any suggestions? |
Thread Tools | |
Display Modes | |
|
|