mail merge - ever have number formatting issues?

from main document press ALT-F9  the fields will display:

{MERGEFIELD "Salary"}

if you edit this to:

{MERGEFIELD "Salary" \# $###,###.00} or variations of that - it will allow you to alter the mail merge documents number format displayed.

this is where Salary - is the name of the field

the Backslash starts the formatting switch

the first # sign defines the switch - this would be numbers, @ would be date .. .I'll look into the others later

the $ sign is a character to be displayed permanently infront of the number ... this could even be text.

the ###,### is the maximim number of digits you want to appear commas where ever you want them

the decimal and in this case 2 deicmals of detail / you can choose more or less