Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Currency format - Excel to Word Merge | Microsoft Word Help | |||
Word merge field names vs. Excel merge field names | Mailmerge | |||
Macros - Keyboard Commands | Microsoft Word Help | |||
How do I merge Word document with Excel one? | Microsoft Word Help | |||
How to change merge forms from Word Perfect to Microsoft Word | Microsoft Word Help |