Mail merge repeating decimals issue

jmorris33 · #1 01-10-2015, 09:12 PM

I'm trying to mail merge an email to students using excel data into word. I have their GPA in excel and want to put it into word for mail but their GPA is displayed in repeating decimals. How can I get rid of the repeating numbers/decimals and only have x.xx instead of x.xxxxxxxx

See attachment for picture of repeating decimals

macropod · #2 01-10-2015, 10:05 PM

This is discussed in the 'Mailmerge Tips & Tricks' thread at the top of this forum - see 'Mailmerge Number & Currency Formatting' there.

jmorris33 · #3 01-10-2015, 11:54 PM

Thank you! Finally an end to trying to figure this out.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail Merge Formatting Issue with Conditional IFs	robbeh	Mail Merge	5	07-08-2014 07:39 AM
time field issue in mail merge	Aude	Mail Merge	16	05-18-2014 06:22 AM
Issue with date format in mail merge document	walshjod	Mail Merge	4	11-28-2012 04:46 AM
Access to Word Mail Merge Issue (255 characters)	ChrisPine	Mail Merge	1	02-16-2012 10:01 PM
Word 2007 mail merge issue	steelervince	Mail Merge	0	02-17-2010 02:26 PM