Recently, I had to do some custom formatting for mail merge documents in CRM 4.0 and here are a few format examples:
Formatting a Date:
{MERGEFIELD "MyDate" \@ "M/d/yyyy" \*MERGEFORMAT}
If you just wanted to add the current date when creating the document:
{DATE \@ "M/d/yyyy"}
Formatting a number as a currency value:
{MERGEFIELD "MyAmount" \# "$0.00" \*MERGEFORMAT}
Formatting a number as a percentage value:
{MERGEFIELD "MyPercent" *100 \# "0%" \*MERGEFORMAT}
Formatting a number with a specific format:
{MERGEFIELD "MyAccountNumber" \# "00 00 000" \*MERGEFORMAT}
Enjoy!!
