Date format in merged field

[David D.]

I am using Publisher 2000 (from Office 2000 Pro), under W2K.

I am printing membership cards, merging data from an Excel spreadsheet.

One of the merged text fields on the membership card is a date. How do I
control the date format on the printed cards?

When the spreadsheet had a date format of "8/4", the card printed as "August
8, 2004". I changed the spreadsheet date format to "August 4, 2004". Now
the card prints "8/4/2004". I suspect, however, that it was something else
that I did within Publisher that caused the date format results.

- David D.

 

[°°°MS°Publisher°°°]

You will need to export/SAVE AS in CSV (Comma Separated Values) from Excel
and use that file as your merge file.

 

[David D.]

Thanks. That works fine.