When using Excel spreadsheets in a mail merge process, many users often encounter problems formatting fields that contain decimals or other numeric values. To ensure that the data in the fields is inserted correctly, one must format the field, not the data in the source file.
Formatting mail merge numbers with decimals and commas
Unfortunately, Word does not provide a way to change how many decimal places are displayed when working with numbers. While there are ways to get around this limitation, the best solution is to include a switch in the merge field.
Field code switches let you change the resulting data that you merge into a document. There are two types of switches in Word:
All switches begin with a backslash, followed by a character (or characters) describing their function. A Numeric Picture Field Switch (/#) specifies the display of a numeric result.
