Thread: Hyphens in Sort Code not appearing in mail merged Word document
View Single Post
 
Old 11-12-2021, 02:31 AM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2019
Expert
  
Join Date: Aug 2014
Posts: 4,106
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 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