Formating Mail Merged numbers 3

[Gavona]

I am constructing a mail merge using Word 2010 to construct an (HTML) email. The mail includes a table containing merged fields. How can I format the numbers to 2 decimal places and with thousands separators? Can Word do this or must I change numbers to formatted text in my source table.

In case it helps, the source for the data is a pivot table in an excel workbook (or in fact a named range covering the relevant area of the pivot table).

Many thanks,

Gavin

Gavin

 

[combo]

For space as thousands separator and standard dot (.) decimal separator:
{ MERGEFIELD FieldName \# #\ ##0.00}
For comma as thousands separator use "," instead of "\ ".

combo

 

[Gavona]

Thanks Combo. I got divertedto something else but will get back to this next week

Gavin

 

[macropod]

The correct numeric formatting switch would be something like:
{MERGEFIELD FieldName \# ",0.00"}
Combo's approach would only be needed if you require a space for the thousands separator AND you're prepared to have numbers less that 1000 padded out.

For more, see Mailmerge Number & Currency Formatting in the Mailmerge Tips and Tricks thread at:

http://www.msofficeforums.com/mail-merge/21803-mailmerge-tips-tricks.html

or:

http://windowssecrets.com/forums/showthread.php/163017-Word-Mailmerge-Tips-amp-Tricks

Cheers
Paul Edstein
[MS MVP - Word]

 

[Gavona]

Thanks Paul, Whilst I was able to figure the format codes, those links deserve more than one star!

I have got it all working.

Gavin