OfficeFrustration

OfficeFrustration (http://www.officefrustration.com/index.php)
-   New Users (http://www.officefrustration.com/forumdisplay.php?f=7)
-   -   Sorting Problem (http://www.officefrustration.com/showthread.php?t=1119171)

EngrJohn June 3rd, 2010 02:22 PM

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?

Gord Dibben June 3rd, 2010 02:47 PM

Sorting Problem
 
I would say your data is Text.

Format all to General.

Copy an empty cell.

Select the range to change and paste specialaddokesc.

Now try the sort.


Gord Dibben MS Excel MVP

On Thu, 3 Jun 2010 06:22:11 -0700, EngrJohn
wrote:

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?




All times are GMT +1. The time now is 10:01 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
OfficeFrustration.com