Wrong Date format

I am trying to merge data from an excel spreadsheet with publisher and am
getting the wrong date format produced for example the excel spreadsheet
contains a date format 24/05/08 and the result i get is 05/24/08. I have
checked all the obvious and
with regional, keyboard and locale all being okay
--
Thanks and regards
Tony

This referes to a Word merge, from Excel, perhaps similar applies to
Publisher

This is because you are using the default OLE DB data connection and
it only passes the data from Excel to Word which does not include
formatting.

You'll need to add a Date-Time picture switch to the merge field in
Word:

- Press Alt + F9 to toggle the field codes
- At the end of your date field add: \@ dd/MM/yy
- Press Alt + F9 to toggle off the field codes

Note that the month format must be in uppercase. A lowercase 'm' is
for minutes

"Tony L" <tony.lodder@stdavidsschool.com(pleasedonotspam) > wrote in message
news:6234B4D0-FCBC-4EE7-9FAE-A01855528880@microsoft.com...
>I am trying to merge data from an excel spreadsheet with publisher and am
> getting the wrong date format produced for example the excel spreadsheet
> contains a date format 24/05/08 and the result i get is 05/24/08. I have
> checked all the obvious and
> with regional, keyboard and locale all being okay
> --
> Thanks and regards
> Tony

alt+ F9 does not work, at least i can't get it to work
--
Thanks and regards
Tony


"DL" wrote:

> This referes to a Word merge, from Excel, perhaps similar applies to
> Publisher
>
> This is because you are using the default OLE DB data connection and
> it only passes the data from Excel to Word which does not include
> formatting.
>
> You'll need to add a Date-Time picture switch to the merge field in
> Word:
>
> - Press Alt + F9 to toggle the field codes
> - At the end of your date field add: \@ dd/MM/yy
> - Press Alt + F9 to toggle off the field codes
>
> Note that the month format must be in uppercase. A lowercase 'm' is
> for minutes
>
> "Tony L" <tony.lodder@stdavidsschool.com(pleasedonotspam) > wrote in message
> news:6234B4D0-FCBC-4EE7-9FAE-A01855528880@microsoft.com...
> >I am trying to merge data from an excel spreadsheet with publisher and am
> > getting the wrong date format produced for example the excel spreadsheet
> > contains a date format 24/05/08 and the result i get is 05/24/08. I have
> > checked all the obvious and
> > with regional, keyboard and locale all being okay
> > --
> > Thanks and regards
> > Tony
>
>
>