[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