Hi
Andy,
To round down a number in a mail merge, you can use the
ROUND function in Microsoft Word. Here's how:
- In your Word document, click on the field that contains the number you want to round down.
- Press Ctrl + F9 to insert field brackets {}. The cursor should be inside the brackets.
- Type "ROUND" followed by a space.
- Type the name of the field that contains the number you want to round down, enclosed in double quotes. For example, if your field name is "Number", you would type "Number".
- Type a comma (,) followed by the number of decimal places you want to round down to. For example, if you want to round down to 1 decimal place, you would type 1.
- Close the field brackets by pressing Ctrl + F9 again.
Your field code should now look something like this:
PHP Code:
{ROUND "Number", 1}
When you preview or complete the mail merge, the number should be rounded down to the specified number of decimal places.