[Chris B.]

I need to merge specific dollar amounts in different letters in a mail merge,
but the numbers won't come over from excel properly.

For example, one dollar amount is $85.07 but it came through in the mail
merge as 85.070000000000007. I tried formatting it in excel as currency but
that didn't work either.

Any suggestions?

Thanks
Christine

[Doug Robbins - Word MVP]

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

"Chris B." wrote in message
...
I need to merge specific dollar amounts in different letters in a mail
merge,
but the numbers won't come over from excel properly.

For example, one dollar amount is $85.07 but it came through in the mail
merge as 85.070000000000007. I tried formatting it in excel as currency
but
that didn't work either.

Any suggestions?

Thanks
Christine

[Chris B.]

Thank you for your help. I got it to work!

Chris B

"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

"Chris B." wrote in message
...
I need to merge specific dollar amounts in different letters in a mail
merge,
but the numbers won't come over from excel properly.

For example, one dollar amount is $85.07 but it came through in the mail
merge as 85.070000000000007. I tried formatting it in excel as currency
but
that didn't work either.

Any suggestions?

Thanks
Christine