Merging data from Excel to Word doc

B

Bperiod

When trying to merge figures from Excel 97 to Word XP, I cannot get th
$ figures to round off. Ex. $412.3344, needs to merge to Word as $412
Any suggestions? Thank you
 
B

Bernie Deitrick

B.,

Move the values to another range, and replace them with a formula like:
=ROUND(AA1,0)
where AA1 is the first cell of the range you moved them to.

Fill with the formula, and that should do it.

HTH,
Bernie
MS Excel MVP
 
Top