Re: Wrong Date format by tony
tony
Tue May 06 05:38:01 PDT 2008
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
>
>
>