Sorting columns

[!Jerry]

I'm trying to sort a column of address information (street number and street
name) but the street number is being sorted from the left rather than as a
number

198
199
2
20
200
2003
201

The column is formated as numbers but there are some alpha characters in a
few of the entries.

Any ideas? Thanks.


(I posted a longer message earlier but when I tried to read it, it was no
longer available on the server... very odd. Sorry if you're seeing
duplicate messages)

 

[Don Guillett]

Are you and Sparky the same person?

 

[Ken Russell]

That's because you have formatted the numbers as text. Format the cells as
numbers.

--
Ken Russell

| I'm trying to sort a column of address information (street number and
street
| name) but the street number is being sorted from the left rather than as a
| number
|
| 198
| 199
| 2
| 20
| 200
| 2003
| 201
|
| The column is formated as numbers but there are some alpha characters in a
| few of the entries.
|
| Any ideas? Thanks.
|
|
| (I posted a longer message earlier but when I tried to read it, it was no
| longer available on the server... very odd. Sorry if you're seeing
| duplicate messages)
|
|

 

[David McRitchie]

Oh, Oh, multiple personalities sharing the same email address.
Kind of a hit an run by anonymous posters. No accountability.

 

[jmurck]

I often find that using the character format function does not
necessarily change the data type, particulary in highly formated
spreadsheets, most often received from someone (not created by me).

When this is the case, I copy the column(s) of data into Notepad, then
copy from Notepad to a new Excel worksheet. Although a somewhat
convoluted process, it seems to do the trick and allow me to set the
data type correctly and sort correctly.