Using formula-generated figures in excel in mail-merging

  • Thread starter Thread starter bluestar
  • Start date Start date
B

bluestar

I am trying to create a database that contains 1 column of fixed numbers with
2 decimals, when the adjacent column containing formula-generated figures
also at 2 decimals. But when I try to transfer those formula-generated
figures into a letter mail-merge, those figures are carried out to up to 16
places. Consequently I have to manually delete those extra 14 places in each
and every letter to be mailed out. Is there any way I can prevent this?
 
Encase your formula within the ROUND function.
=ROUND(YourFormulaHere,2)

Now you truly only have 2 decimals (not just displaying only two decimals)
so you can copy it itno your mail-merge just fine.
 
Back
Top