Date format in mailmerge

A

Anil Gupta

I have made a regional setting of date in format
dd/MM/yyyy. Excel respects this setting when I enter the
dates. I use this excel sheet as a data source for a word
mailmerge document. Here word interprets the date
diffrently. For dates where day value is less than 12 it
uses the day as month and month as day. For other dates
where day value is more than 12 the date is displayed
correctly. Can any one suggest a solution to this.

Anil Gupta
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
How to add day to PWA 2016 date format? 0
Date Formats 4
Publisher is filling blank lines with data 2
date format convert 3
International Date formatting 6
Date Field - Switch to Suppress 2
Forcing a date entry format of dd/mm/yyyy 1

Top