I am trying to do Mail Merge letters from Excel into Word, but some of the
cells in Excel will be calculated fields with formulas. I want Word to bring
in the results of the calculation, not the formula in the cell and the format
(cell is formatted as currency, but Word brings in just the number. I am
fairly new to Word, have always used Word Perfect in the past. Any help on
this would be greatly appreciated. I also have to bring in percentages (like
44.4%) but to get this merged in correctly I have to make the cell "Text",
but I need to have it as percent because it is part of my calculations
mentioned above. If you can't help me, then maybe you can tell where to go
or look or what book to purchase to help me with this. Thanks -- CC Frosh

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"cc frosh" cc wrote in message
news
I am trying to do Mail Merge letters from Excel into Word, but some of the
cells in Excel will be calculated fields with formulas. I want Word to
bring
in the results of the calculation, not the formula in the cell and the
format
(cell is formatted as currency, but Word brings in just the number. I am
fairly new to Word, have always used Word Perfect in the past. Any help
on
this would be greatly appreciated. I also have to bring in percentages
(like
44.4%) but to get this merged in correctly I have to make the cell "Text",
but I need to have it as percent because it is part of my calculations
mentioned above. If you can't help me, then maybe you can tell where to
go
or look or what book to purchase to help me with this. Thanks -- CC Frosh

See http://www.gmayor.com/formatting_word_fields.htm and the Excel data
section of http://www.gmayor.com/mail_merge_lab...th_word_xp.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


cc frosh wrote:
I am trying to do Mail Merge letters from Excel into Word, but some
of the cells in Excel will be calculated fields with formulas. I
want Word to bring in the results of the calculation, not the formula
in the cell and the format (cell is formatted as currency, but Word
brings in just the number. I am fairly new to Word, have always used
Word Perfect in the past. Any help on this would be greatly
appreciated. I also have to bring in percentages (like
44.4%) but to get this merged in correctly I have to make the cell
"Text", but I need to have it as percent because it is part of my
calculations mentioned above. If you can't help me, then maybe you
can tell where to go or look or what book to purchase to help me with
this. Thanks -- CC Frosh