Excel Decrease Decimal Pro Journalist Who

James Marshall is a pro journalist who covers technology and computer troubleshooting.

He is also skilled with Microsoft Word, Apple Pages, and other word processors.

To ensure the data contained in the fields are inserted correctly, one must format the field, not the data in the source file.

Unfortunately, Word does not provide a way for you to change how many decimal places are displayed when working with numbers.

While there are ways to work around this limitation, the best solution is to include a switch in the merge field.

Excel Decrease Decimal Code Switches Allow

Field code switches allow you to modify the resulting data that you merge into a document.

For instance, you could use a general switch to select uppercase letters.

Field switches are field-specific, changing the behavior of the fields to which they are applied.

All switches begin with a backslash, followed by a character (or characters) that describe its function.

A Numeric Picture Field Switch () determines the display of a numeric result.

Learn how to use the Numeric Picture Field Switch ( ) to specify how many decimal places to display in your Word mail merge.

With the mail merge main document open, press Alt F9 to view the field codes.

Directly after the end quote around the field name type followed by.

Your number will appear rounded to the decimal place you specify.

If it does not display immediately, refresh the document by minimizing it to the toolbar and reopening it.

If the field value still does not display correctly, you may need to refresh the document again or close and re-open your document.