Merging data from Excel to Word doc

  • Thread starter Thread starter Bperiod
  • Start date Start date
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.,

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
 
You must log in or register to reply here.

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

Similar Threads

Mail Merge Formating Issues 3
How to subtract a number from a Mergefield? 0
Why does my excel to word mail merged doc not merge last entry? 3
Mail Merge - Thousand separators & Decimals 0
Mail Merge - Thousand separator and decimals 1
Merge data from an ascii file into a Word doc 1
Mail Merge issue 4
Mail Merge from Excel 2

Back
Top