When doing a mail merge into Word using an Excel file, any field formatted as currency or accounting in Excel does not carry the formatting into Word. Although you can just add a dollar sign prior to the mergefield, it doesn't help when some numbers are whole and others are decimals. Who wants to view the amount they owe as $15.3? I'd prefer the forced placeholder for the cents (decimal places) to see it as $15.30.
- Right-click the mergefield and select Edit Field.
- Click the Field Codes button in the lower-left corner.
- Click behind the mergefield name and then type the switch for a numeric picture (\#).
- Use # for optional numbers and 0 (zero) for required numbers.
- Click OK and preview your results.
Here's an example how some may look:
MERFIELD Price \# $#,##0.00 = $1,234.56 or $789.00
MERFIELD Price \# $#0.00 = $12.34 or $56.00
MERFIELD Price \# $#,##0 = $1,234 or $567.00
0 comments:
Post a Comment