Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-17-2021, 10:03 AM
samshagger samshagger is offline Mail Merge Exponent Format Windows 10 Mail Merge Exponent Format Office 2016
Novice
Mail Merge Exponent Format
 
Join Date: Mar 2021
Posts: 1
samshagger is on a distinguished road
Default Mail Merge Exponent Format

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!
Reply With Quote
  #2  
Old 03-17-2021, 03:58 PM
macropod's Avatar
macropod macropod is offline Mail Merge Exponent Format Windows 10 Mail Merge Exponent Format Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 03-17-2021, 06:58 PM
macropod's Avatar
macropod macropod is offline Mail Merge Exponent Format Windows 10 Mail Merge Exponent Format Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
mailmerge field, word2016

Thread Tools
Display Modes


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 Exponent Format Mail merge date format Highlander01 Mail Merge 1 07-28-2016 05:05 PM
Mail Merge Exponent Format Mail Merge with correct format amentinho Mail Merge 14 10-10-2015 09:23 PM
Mail Merge Exponent Format Mail Merge Format random 0s lmoir87 Mail Merge 2 07-31-2014 03:45 AM
Mail Merge Exponent Format Change Mail Merge Date Format from US to UK Evanaught Mail Merge 1 09-29-2013 08:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:08 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft