Sorting Problem

E

EngrJohn

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?
 
G

Gord Dibben

I would say your data is Text.

Format all to General.

Copy an empty cell.

Select the range to change and paste special>add>ok>esc.

Now try the sort.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top