Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
number format in word to show the comma as a seperator
I am doing a email merge (excel to word) but when I have my numbers in execl
carry over...even though in Excel they have the comma seperator...it does not carry over to my word letter doc....can you tell me how to bring the commas into my word document. |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
number format in word to show the comma as a seperator
Hi Debi,
In Word, add a numeric picture switch to the mergefield. To do this: .. select the field; .. press Shift-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 The precision of the displayed value is controilled by the '0.00'. You can use anything from '0' to '0.000000000000000'. If you use a final ';' in the formatting switch with nothing following, (eg \# $,0.00;($,0.00) zero values will be suppressed. Note that this suppresses 0s resulting from empty fields and from fields containing 0s. -- Cheers macropod [MVP - Microsoft Word] "Debi" wrote in message ... I am doing a email merge (excel to word) but when I have my numbers in execl carry over...even though in Excel they have the comma seperator...it does not carry over to my word letter doc....can you tell me how to bring the commas into my word document. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comma-delimited text format | Microsoft Word Help | |||
Field, Numeric: decimal point AND comma format ? | Tables | |||
Either format numbers in cell or comma on 10-key? | Microsoft Word Help | |||
What is ASCII Foxed Width or comma delimited format? | Microsoft Word Help | |||
Want to use 100 seperator instead of 1000 seperator | Microsoft Word Help |