Wrong Date format

T

Tony L

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
 
D

DL

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
 
T

Tony L

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


DL said:
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
Click to expand...
 
Top