Mail merge - date format

[Abhijitp]

I face a problem very often with mail merge of changing date formats.
even tried by putting date in text format in the excel data sheet bu
it still shows the date in the same format.

eg:
I want to display date as 1-Jun-08, I set same date format in excel
When i open it in word the format changes to 6/11/08 automatically.

Then i tried changing the date format as text in the cell by puttin
'1-Jun-08, but the same result.

Please help..

A

 

[Graham Mayor]

Add a date switch to the merge field eg

{Mergefield Datefieldname \@ "d-MMM-yy"}

see http://www.gmayor.com/formatting_word_fields.htm

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>