Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Hyphens in Sort Code not appearing in mail merged Word document
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 11-12-2021, 02:31 AM
gmayor's Avatar
gmayor gmayor is offline Hyphens in Sort Code not appearing in mail merged Word document Windows 10 Hyphens in Sort Code not appearing in mail merged Word document Office 2019
Expert
  
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
You didn't answer the question -'What does { MERGEFIELD F12 } produce?' i.e. what is the underlying value in the cell. How it is formatted in Excel is not relevant as Word ignores the formatting.

If the value in the cell is 00-00-00 then that's what the merge should produce.
If the value in the cell is (say) 265476 then you need { MERGEFIELD F12 \# "00'-'00'-'00" }
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyphens in Sort Code not appearing in mail merged Word document changing drop down menus in a mail-merged document Taras49 Word 4 02-27-2017 11:30 AM
Hyphens in Sort Code not appearing in mail merged Word document Mail merged document and page numbers for table of contents jab40 Mail Merge 20 04-07-2016 08:25 AM
Hyphens in Sort Code not appearing in mail merged Word document Cannot get macro button to sort with merged cells on sheet lonniepoet Excel Programming 3 02-04-2016 04:33 PM
Hyphens in Sort Code not appearing in mail merged Word document decimal numbers not appearing properly in merged document paulys Mail Merge 2 08-06-2012 08:15 AM
saving a mail merged document after the user edits it. kosh2 Mail Merge 0 08-05-2011 03:35 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:19 AM.

Contact Us - Privacy Statement - Top

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