Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
bamny
 
Posts: n/a
Default merge currency incl .00 from excel into word doc

When merging a currency field from Excel, it will merge any cents (example
$23.32), but if it's zero cents, it will not print the zeros (example
$23.00). How do I get it to include the .00?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default merge currency incl .00 from excel into word doc

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

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


--
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

"bamny" wrote in message
...
When merging a currency field from Excel, it will merge any cents (example
$23.32), but if it's zero cents, it will not print the zeros (example
$23.00). How do I get it to include the .00?



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
bamny
 
Posts: n/a
Default merge currency incl .00 from excel into word doc

I appreciate your response, but it's way more than I can interpret. It
should be a simple matter for us technically-challenged people to do. Thanks
anyway!

"Doug Robbins - Word MVP" wrote:

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

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


--
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

"bamny" wrote in message
...
When merging a currency field from Excel, it will merge any cents (example
$23.32), but if it's zero cents, it will not print the zeros (example
$23.00). How do I get it to include the .00?




  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor
 
Posts: n/a
Default merge currency incl .00 from excel into word doc

The use of switches on fields is elementary stuff and if you want Word to
produce the merges you require you are going to have to bite the bullet and
learn about it.

Select the offending field which will probably look like
fieldname
Right click and toggle the display to show
{Mergefield fieldname}
Within the brackets add the switch

{Mergefield fieldname \# "$,0.00"}
Press F9 then if necessary toggle the display back again.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


bamny wrote:
I appreciate your response, but it's way more than I can interpret.
It should be a simple matter for us technically-challenged people to
do. Thanks anyway!

"Doug Robbins - Word MVP" wrote:

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

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


--
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

"bamny" wrote in message
...
When merging a currency field from Excel, it will merge any cents
(example $23.32), but if it's zero cents, it will not print the
zeros (example $23.00). How do I get it to include the .00?



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
Currency format - Excel to Word Merge ckkelliej Microsoft Word Help 1 November 29th 05 03:15 AM
Word merge field names vs. Excel merge field names [email protected] Mailmerge 5 November 11th 05 05:24 PM
Macros - Keyboard Commands Janet Microsoft Word Help 6 April 11th 05 05:28 AM
How do I merge Word document with Excel one? Fermanov Microsoft Word Help 2 March 24th 05 02:03 AM
How to change merge forms from Word Perfect to Microsoft Word dollfindance Microsoft Word Help 2 December 30th 04 03:35 PM


All times are GMT +1. The time now is 08:41 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"