View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Zip + 4 showing as 0 on lables

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

Alternatively, you will need to format the data in Excel as Text.


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"GTS" wrote in message
...
I'm doing a mail merge from an Excel sheet and all the zip codes in the
zip+4
format (12345-1234) are showing up as zeros.

Is there a way to fix this other than doing the switching formulas? I'm
not
that savvy at Word and am intimidated by the formulas. It used to be so
easy!
--
GTS