Hi,
I finally found a fix for this, it involves a little bit of work in Excel.
Basically, find the position of the the decimal place in the number using the =FIND function.
Add 2 to this number.
Using the =LEFT function, select the number of characters which you have determined above.
In the mail merge itself, use switch \# "#,##0.00x" & this will show all of your numbers to 2 decimal places.
Hope this will aid other people who have had the same problem as me!
Regards,
Luke
|