Changing values of a mail merge

[Debbie]

I am doing a mail merge using excel and word. Some values
in the excel document look like this: 4000.03999999999.

Even though it might round in excel to 4000.04, when i do
the mail merge in word, it still looks like
this:4000.03999999999.

I know that a formula exists in word to change it to look
like the 4000.04, but I can't seem to find it. Please
help me someone!!!

Debbie

 

[Doug Robbins]

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

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


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP