I'm having a bizarre problem with Excel sort. My wife has a worksheet with a list (database) of about 1000 names and addresses. She added about 25 records on a new worksheet for labels, then copied the 25 records to the worksheet. The worksheet will not inlcude the new records in the sort by zip code. In the past, this problem may be caused by some records having the zip formatted as numbers, others as text. I have tried everything (copied to word table, new worksheet, dBase 4 format, etc) and no luck. Changed format several times...nothing. She might have unwittingly done something, but I am at my wites end. Any ideas????
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel problem sorting copied data
- Thread starter jfhewitt
- Start date
Hi.
I once had a similar problem in Excel 2000 caused, as you rightly suggested, by the different formats of the cells within the column, ie. text and numbers. Formatting the column had no effect. To solve it I copied the entire cell, then 'paste special' and select the 'add' option. This converted the new column to numbers only.
[Just tried it in XP - had to convert the column to number afterwards].
Maybe this will work for you.
Regards
I once had a similar problem in Excel 2000 caused, as you rightly suggested, by the different formats of the cells within the column, ie. text and numbers. Formatting the column had no effect. To solve it I copied the entire cell, then 'paste special' and select the 'add' option. This converted the new column to numbers only.
[Just tried it in XP - had to convert the column to number afterwards].
Maybe this will work for you.
Regards
- Thread starter
- #4
- Status