Truncate a number using Numeric Format Switch

  • Thread starter Thread starter Trish Gorda
  • Start date Start date
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?
 
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.
 
Back
Top