[Abhijitp]

I face a problem very often with mail merge of changing date formats. I even tried by putting date in text format in the excel data sheet but 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 putting '1-Jun-08, but the same result.

Please help..

AP

[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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Abhijitp wrote:
I face a problem very often with mail merge of changing date formats.
I even tried by putting date in text format in the excel data sheet
but 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 putting
'1-Jun-08, but the same result.

Please help..

AP