Thank-you, I was having trouble getting the switches to work. I found the
following explanation which solved my problem and was easier. (I am working
in Office 2003). http://www.http://www.uwec.edu/help/...-withxls-m.htm


"Doug Robbins - Word MVP" wrote:

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

"slb" wrote in message
...
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?