Importing dates from excel changes formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Danny J - 18 Mar 2005 13:05 GMT

Hi folks,

I am using a spreadsheet as my data source. The date field in the
spreadsheet is formatted in European date style (ie 28th feb 2005 is
28/02/2005), but when I use a merge field the fromatting is changed to US
date style (02/28/2005). any ideas?

Thanks,

Dann

Reply to this Message

Greg - 18 Mar 2005 13:16 GMT

Dan,

Try using a date format picture switch in your merger field

{Mergefield "your merge field" \@ "dd/MM/yy"}

or look at your regional settings in windows and see if your short date
format is set to the european format.

Reply to this Message

Greg - 18 Mar 2005 13:23 GMT

Danny,

Better yet, See the "Dates: day/month reversed" item under the
"Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.htm

Reply to this Message

msnews.microsoft.com - 28 Mar 2005 09:20 GMT

Many Thanks

Dan

Danny,

Better yet, See the "Dates: day/month reversed" item under the
"Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at
http://homepage.swissonline.ch?/cindymeister/MergFram.htm

Reply to this Message