Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge dollar amounts
I need to mail merge currancy numbers and when I merge the commas and dollar
signs disappear when in the word document. Is there a way to have them come over with the numbers? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge dollar amounts
Hi el96jay,
In Word, add a numeric picture switch to the mergefield. To do this: .. select the field; .. press Ctrl-F9 to reveal the field coding. It should look something like {MERGEFIELD MyData}; .. edit the field so that you get {MERGEFIELD MyData \# $,0.00} (or whatever other numeric format you prefer - see below); .. position the cursor anywhere in this field and press F9 to update it; .. run your mailmerge. Note: The '\# 0' in the field is referred to as a numeric picture switch. Other possibilities include: .. \# 0 for rounded whole numbers .. \# ,0 for rounded whole numbers with a thousands separator .. \# ,0.00 for numbers accurate to two decimal places, with a thousands separator .. \# $,0 for rounded whole dollars with a thousands separator .. \# $,0.00;($,0.00);- for currency, with brackets around negative numbers and a hyphen for 0 values -- Cheers macropod [MVP - Microsoft Word] "el96jay" wrote in message ... I need to mail merge currancy numbers and when I merge the commas and dollar signs disappear when in the word document. Is there a way to have them come over with the numbers? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lining Up Dollar Amounts | Microsoft Word Help | |||
Merge field comparing dollar amounts? | Mailmerge | |||
I am trying to merge dollar amounts from an Excel spreadsheet | Mailmerge | |||
right justify dollar amounts | Mailmerge | |||
mail merge dollar amounts | Microsoft Word Help |