Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Importing dates from excel changes formatting
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 |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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=AD/ci...r/MergFram.htm |
#4
|
|||
|
|||
Many Thanks
Dan "Greg" wrote in message oups.com... 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*/cind...r/MergFram.htm |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I retain formatting from an Excel Data File to a Word Merg. | Microsoft Word Help | |||
Importing data from excel into word | Microsoft Word Help | |||
Importing from Excel | New Users | |||
Formatting EXCEL spreadsheet onto WORD document | Page Layout | |||
formatting links from excel into word (extra line feeds) | Microsoft Word Help |