Importing dates from excel changes formatting

[Danny J]

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

 

[Greg]

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.

 

[Greg]

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

 

[msnews.microsoft.com]

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