date format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Reggiee - 29 Aug 2006 13:24 GMT

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 to this Message

Graham Mayor - 29 Aug 2006 14:19 GMT

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

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hi All,
>
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message

Reggiee - 29 Aug 2006 16:11 GMT

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

> Use a date switch - http://www.gmayor.com/formatting_word_fields.htm
>
[quoted text clipped - 7 lines]
> >
> > Thanks

Reply to this Message

Graham Mayor - 30 Aug 2006 06:29 GMT

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.

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Good god - Ive seen it all now !!
>
[quoted text clipped - 25 lines]
>>>
>>> Thanks

Reply to this Message

Rate this thread: