I'm trying to create a word document with information merged from excel. I
can't get the numbers to round to 2 digits after the decimal point. Once the
information is merged into the word document it carries the full number.
I've tried rounding the excel cells first, but that didn't work. I'm using
Office XP.

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

"Coos Woman" Coos wrote in message
...
I'm trying to create a word document with information merged from excel.
I
can't get the numbers to round to 2 digits after the decimal point. Once
the
information is merged into the word document it carries the full number.
I've tried rounding the excel cells first, but that didn't work. I'm
using
Office XP.