Sorting error in Excel 2000 (XPH SP2)

[Guest]

Hia all,

I have a table with 650 addresses and want to sort them
as per postal codes in column A - small country, all 4 digits.

There is just no way to do so. I've read Help "If sorting results are not as
expected" (retranslated from German), but to no avail. I select the column
and change cell format to numbers, or text, but still no go. There are no
apparent leading empty digits.

Any ideas? many thanks
flowe

 

[Guest]

Changing the format of a cell changes how it is displayed; it does not change
the actual value in the cell. In particular, changing the format will not
change a value from number to text or visa versa.

Changing the format does prepare the cell to receive the specified data
type, so you could then re-enter the values after formatting. Alternately,
to convert all values to numbers, copy an empty cell, select the range of
postal codes, and Edit|Paste Special|Add. To convert all values to text, you
can use a helper column with a formula like =A1&""; copy the cells from the
helper column and Edit|Paste Special|Values back into the original location.

The subject of this group is things that cause Excel to crash. Your post
would have been more on topic in the general group.

Jerry

 

[Guest]

Jerry

Rather belated, I want to thank you for the in-depth and helpful reply.
I don't like it too not getting any feedback after trying to help others.
Sorry

Regards
flowe