How do I stop decimal number truncation in mail merge?

B

Bob Emery

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge - displaying a conditional number of decimals 5
Truncation 1
Initial zeros in zip codes getting dropped in Word mail merges 1
Decimal places in mail merge 1
Unable to mail merge $ figures ending in zero 2
How do I stop data from being truncated in a mail merge? 1
Using a Downloaded Template in Mail Merge 1
How do I stop eht SQL Message from opening 1

Top