Mail Merge, Number to 2 Decimal Places

Vampy99 · #1 09-23-2011, 03:39 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Saving INDV mail merges During the mail merge	sedain121	Mail Merge	2	10-04-2011 07:52 PM
Mail merge number fields outputting inconsistently	rekcots	Mail Merge	2	05-18-2011 06:32 AM
My Places	lukewarmbeer	Office	0	07-13-2010 02:33 PM
Convert hours in decimal	ghostones	Excel	1	12-29-2009 09:17 PM
Merge, Too many Numbers right of the Decimal Point	ohdearme	Mail Merge	0	10-25-2009 05:10 PM