Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

LinkBack Thread Tools Display Modes
Old 04-04-2019, 06:52 AM
mblackford mblackford is offline Windows 10 Office 2016
Join Date: Apr 2019
Posts: 1
mblackford is on a distinguished road
Default Can you have date and currency fields detect regional settings for format?

I am trying to create one merge template that can be used worldwide. After searching, it doesn't appear that there is a way to insert a formula/switch/etc to have the date/currency fields format based on the regional settings of the user. But I wanted to just make sure before I give up. Our software application provides merge contracts and proposals to our users. Currently, we allow customers to edit their own merge templates so they can format the dates/currency formats. But we are trying to provide a single set of templates for our limited service product that does not allow them to edit. Any ideas?
Reply With Quote
Old 04-04-2019, 03:38 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,390
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold

You could use custom document properties named, for example, Currency, ShortDate, LongDate, etc. and insert into them the field picture switches you want to use in a given locale. The mergefields, etc. could then be coded along the lines of:
{MERGEFIELD Amount \#"{DOCPROPERTY Currency}"}
In this example, if the 'Currency' custom document property contained €,0.00, the output would be formatted as €1,234,56.

Another approach would be to employ a macro that queries the regional settings upon opening the mailmerge main document and automatically updates those properties for you.

Both approaches have their advantages and disadvantages.
Paul Edstein
[MS MVP - Word]
Reply With Quote

currency, date cell formatting, regional

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Why do currency cells automatically change to date format on some worksheets Hil Excel 1 09-16-2015 10:34 AM
Currency format in form travelred Word 2 11-14-2014 06:15 AM
MS Project to detect task level changes and record a date modified in custom field RJTMEYER Project 3 08-22-2014 07:38 AM
Letter date changes when merging with Excel - not the format, the actual date! Smallweed Mail Merge 1 02-07-2014 06:00 PM
TOC not updated due to regional "separator" settings ajay_p5 Word 3 08-04-2013 05:01 PM

All times are GMT -7. The time now is 10:27 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft