Solved Mail merge a date field screws the formatting!

February 18, 2014 at 06:26:38
Specs: Windows 7
I have an excel sheet with dates displayed in European format dd/mm/yyyy :-)

I import it into a letter ("you have been a member since") and it imports in American mm/dd/yyyy.

I can't see how to properly format the merge field


See More: Mail merge a date field screws the formatting!

Report •


#1
February 18, 2014 at 08:04:28
✔ Best Answer
It all has to do with how your Operating System Date is set up.
If your in the US then the default is mm/dd/yyyy

You can change how Excel Displays the date to dd/mm/yyyy,
but it Stores the date in the System Date format of mm/dd/yyyy.

When you import the date to Word, the System Date format is used.

See here for how to change the format:

http://cybertext.wordpress.com/2009...
also
http://www.ashbee.co.uk/index.php/f...

MIKE

http://www.skeptic.com/


Report •

#2
February 18, 2014 at 09:39:07
So it looks like I cannot do it - thanks for this you've saved me a lot of time! I thought I was doing something stupid but it is the computer's hidden instructions.

Report •

#3
February 18, 2014 at 11:47:44
So it looks like I cannot do it

Perhaps you still can, there are other Date Fields that Word Uses,
try here:

http://www.addbalance.com/word/date...

Scroll down about a third of the page.

Also, see here:

http://wordfaqs.mvps.org/DateFields...


See if that helps any.

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •
Related Solutions


Ask Question