date format

[Reggiee]

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

 

[Graham Mayor]

Use a date switch - http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Reggiee]

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]

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>