View Single Post
 
Old 09-23-2011, 03:39 AM
Vampy99 Vampy99 is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Jul 2011
Posts: 4
Vampy99 is on a distinguished road
Default

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
Reply With Quote