Sylvester

Having the number and address in the same cell produces text formatted data.

The sort order is correct for this format.

The best way to get around this is to break out the number and address into two
columns and sort on the column with numbers.

Make sure you select all columns before sorting.


Gord Dibben MS Excel MVP

On Mon, 31 Jul 2006 20:15:02 -0700, Sylvester
wrote:

I have a database with adresses of people. I have to print the database in
order of housenumber. The streetname and housenumber are in the same cell. If
i sort my database on the adress, i get the numbers starting with 1 first.
Like 1, 10, 11, 2, 22, 3, 37. How can i sort the right way?

Sylvester