Truncate a number using Numeric Format Switch

T

Trish Gorda

I'm formatting a Word template where my incoming field has several numbers
after the decimal place (ex. 12.45678). I want to format the merge field to
truncate the number of decimal places to 2. (ex. 12.45). Note: I do not
want to round, I just need to drop all numbers after 2 decimal places. Is
there a way to do this?
 
M

macropod

Hi Trish,

Try a field coded as:
{=INT({MERGEFIELD Data}*100)/100 \# 0.00}
or
{=INT(«Data»*100)/100 \# 0.00}

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message. Likwise, you can't type or copy & paste the chevrons (ie '« »') - they're part of the actual mergefields,
which you can insert from the mailmerge toolbar.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top