View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
slb
 
Posts: n/a
Default Word mail merge coming from Excel

I have a complex spreadsheet with multiple calculations and am merging the
data into Word. When I run the merge, I lose all formatting of the numbers,
and about 10 decimal places print. I have added round functions to my
formulas, but still haven't completly solved the problem. How do I bring in
commas, dollar signs and only 2 decimal points when merging with Word?