How do I stop decimal number truncation in mail merge?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob Emery - 18 Jan 2006 20:18 GMT

This may be a repeat as I'm not sure it posted correctly the first time. How
do I stop mail merge from truncating currency figures in the excel database?
My current mail merge eliminates $ signs and all trailing zeros, e.g.,
$643.20 merges as 643.2 and $655.00 merges as 655.

Reply to this Message

Anne Troy - 18 Jan 2006 20:25 GMT

Try this, Bob:
http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

> This may be a repeat as I'm not sure it posted correctly the first time.
> How
> do I stop mail merge from truncating currency figures in the excel
> database?
> My current mail merge eliminates $ signs and all trailing zeros, e.g.,
> $643.20 merges as 643.2 and $655.00 merges as 655.

Reply to this Message