Mail Merge Exponent Format

samshagger · #1 03-17-2021, 10:03 AM

I am working on the mail merge in Word 2016. I have a problem with certain merge fields which obtain data from Excel 2016: long numbers like 44100160145009 are shown in Word as 4,4100160145e+13. In Excel they are shown correctly. Does anyone have any idea what I have done wrong? Thank you!

macropod · #2 03-17-2021, 03:58 PM

You can fix that via the simple expedient of adding a numeric picture switch to the mergefield:
1. Select the mergefield and press Shift-F9. You should see something like { MERGEFIELD Data }
2. Add a '\# 0' numeric picture switch to the mergefield so you get { MERGEFIELD Data \# 0}
3. Press F9 to update the display.
Done.

macropod · #3 03-17-2021, 06:58 PM

Cross-posted at: excel 2016 - Mail Merge Exponent Formatting - Stack Overflow
For cross-posting etiquette, please read: Excelguru Help Site - A message to forum cross posters

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail merge field mistakenly interpret text format as date format	alan6690	Mail Merge	0	09-02-2020 01:54 AM
Mail merge date format	Highlander01	Mail Merge	1	07-28-2016 05:05 PM
Mail Merge with correct format	amentinho	Mail Merge	14	10-10-2015 09:23 PM
Mail Merge Format random 0s	lmoir87	Mail Merge	2	07-31-2014 03:45 AM
Change Mail Merge Date Format from US to UK	Evanaught	Mail Merge	1	09-29-2013 08:02 PM