#1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Melissa Melissa is offline
external usenet poster
 
Posts: 75
Default sorting

How do you sort 5 digit zips with zip+4's correctly?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Cindy M. Cindy M. is offline
external usenet poster
 
Posts: 2,416
Default sorting

Hi ?B?TWVsaXNzYQ==?=,

How do you sort 5 digit zips with zip+4's correctly?

In what context, more specifically? And in which version of
Word?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)

  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Melissa Melissa is offline
external usenet poster
 
Posts: 75
Default sorting

I have Microsoft Word 2003 & my addresses are in Microsoft Office Excel 2003.
The zip + 4 codes sort after the highest 5 digit zip code, instead of in
with the 5 digit codes, both in Excel & in mail merge. I need to know how to
sort them, either in Excel or in mail merge. Thanks!

"Cindy M." wrote:

Hi ?B?TWVsaXNzYQ==?=,

How do you sort 5 digit zips with zip+4's correctly?

In what context, more specifically? And in which version of
Word?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)


  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Cindy M. Cindy M. is offline
external usenet poster
 
Posts: 2,416
Default sorting

Hi ?B?TWVsaXNzYQ==?=,

I have Microsoft Word 2003 & my addresses are in Microsoft Office Excel 2003.
The zip + 4 codes sort after the highest 5 digit zip code, instead of in
with the 5 digit codes, both in Excel & in mail merge. I need to know how to
sort them, either in Excel or in mail merge. Thanks!

See if this does what you're looking for

1. Select the ZIP column in Excel
2. From the Data menu, choose "Text to columns"
3. Click through to Step 3 and activate "Text" as the data type, so that Excel
explicitly formats the data as text and not as numeric

Now both Excel and Word should sort the column based on the first, second, etc.
numbers (characters) in each cell.

If you don't format the data as text, Word (at least) will try to perform a
subtraction (due to the -) before sorting.

How do you sort 5 digit zips with zip+4's correctly?

In what context, more specifically? And in which version of
Word?



Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Need option to ignore quotation marks in sorting bibliography. Syntactician Microsoft Word Help 1 July 6th 05 11:17 PM
sorting alphanumerically in a table Fred Microsoft Word Help 2 February 5th 05 05:47 PM
Sorting a table while keeping some related rows together Dan Corban Tables 7 January 20th 05 07:31 PM
Sorting - Toolbar or Menubar? Hélène Tables 4 January 6th 05 06:25 PM
UNICODE SORTING Rebecca New Users 1 December 27th 04 05:07 PM


All times are GMT +1. The time now is 05:26 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"