Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
date format
Hi All,
Am doing a mail merge using Word where the fields I need are stored in an excel spreadsheet. One of these is a date column eg 29/06/2006 but when this field is linked into Word it appears as 6/29/06 ie it seems to be taking the US date format and not UK one - all my regional settings are set to UK so I dont think its that. Any clues? Thanks |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
date format
Use a date switch - http://www.gmayor.com/formatting_word_fields.htm
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Reggiee wrote: Hi All, Am doing a mail merge using Word where the fields I need are stored in an excel spreadsheet. One of these is a date column eg 29/06/2006 but when this field is linked into Word it appears as 6/29/06 ie it seems to be taking the US date format and not UK one - all my regional settings are set to UK so I dont think its that. Any clues? Thanks |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
date format
Good god - Ive seen it all now !!
And here was me hoping for a simple answer. Thanks Graham as Ive never used/heard of these switches before - still find it bizarre that MS with all their years of programming etc cant allow us brits to stick with dd/mm/yyyy lol Russ "Graham Mayor" wrote: Use a date switch - http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Reggiee wrote: Hi All, Am doing a mail merge using Word where the fields I need are stored in an excel spreadsheet. One of these is a date column eg 29/06/2006 but when this field is linked into Word it appears as 6/29/06 ie it seems to be taking the US date format and not UK one - all my regional settings are set to UK so I dont think its that. Any clues? Thanks |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
date format
The software is American and the interface between Word and its data
accesses only the raw data stored in a US format. If you want it reproduced in some other layout you have to tell it what you want. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Reggiee wrote: Good god - Ive seen it all now !! And here was me hoping for a simple answer. Thanks Graham as Ive never used/heard of these switches before - still find it bizarre that MS with all their years of programming etc cant allow us brits to stick with dd/mm/yyyy lol Russ "Graham Mayor" wrote: Use a date switch - http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Reggiee wrote: Hi All, Am doing a mail merge using Word where the fields I need are stored in an excel spreadsheet. One of these is a date column eg 29/06/2006 but when this field is linked into Word it appears as 6/29/06 ie it seems to be taking the US date format and not UK one - all my regional settings are set to UK so I dont think its that. Any clues? Thanks |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to suppress autotext US date format after typing current year | Microsoft Word Help | |||
Date format question | Mailmerge | |||
Change date format for Comments and display date in balloons | Microsoft Word Help | |||
Wrong mail merge date format | Mailmerge | |||
TextFile / Word 2000 Date format | Mailmerge |