Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
SToon63
 
Posts: n/a
Default ZIP with decimal added

I read a similar post on this after doing a search, but admit the answer
wasn't clear. The problem: when I do a mail merge into Word from an Excel
file, the ZIP field imports with a decimal place and zero afterward (ie:
77449.0).

The previous answer from Graham Mayor was this:

"You cannot alter the inserted field zip. You must toggle the field to
{Mergefield Zip} before adding the switch, then F9 to update - see
http://www.gmayor.com/formatting_word_fields.htm"

I don't know what "toggle the field" means or how you get to "{mergefield
Zip}. What is a "switch"? I did go to the suggested webpage and was still
confused. I succeeded in adding the "view field codes" button to my toolbar,
but don't know how to use it. Also, I saw nothing on the webpage regarding
the decimal problem.

Sorry for my ignorance of directions that are probably clear to most, but I
could use your additional help. Thanks.

 
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
Round numbers to 2 decimal places when using Word Mail Merge ALJ Mailmerge 3 April 30th 23 02:49 PM
Typing a repeating decimal in Word - needs overstrike wolfie Microsoft Word Help 7 April 22nd 23 06:35 AM
How can I have numbered items line up (justify) at the decimal pl. DBASKnight Microsoft Word Help 1 February 26th 05 09:50 PM
Mailmerge wont see Added Excel Data source Columns Thatdampwood Mailmerge 3 December 2nd 04 10:56 PM
aligning decimal? Margreta Microsoft Word Help 1 November 26th 04 11:39 AM


All times are GMT +1. The time now is 10:00 PM.

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

About Us

"It's about Microsoft Word"