how to get excel formatted date in word during mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

azhagesan - 20 Dec 2005 06:52 GMT

When I tried to merge custom formated date (mmmm dd, yyyy) from excel, the
merged document is showing the date as number. How to have the date in the
format i required. I am using Office 2003

Reply to this Message

macropod - 22 Dec 2005 11:45 GMT

Hi azhagesan,

What sort of number are you getting (eg 38708, 12202005)?

Cheers

> When I tried to merge custom formated date (mmmm dd, yyyy) from excel, the
> merged document is showing the date as number. How to have the date in the
> format i required. I am using Office 2003

Reply to this Message

Sheila D - 22 Dec 2005 11:49 GMT

You need to re-format the date in Word - something like DATE \@ "dd/MM/yyyy"
where DATE is your field name. If you hit Alt/F9 you will see the field
format rather than the result. Then Alt/F( to switch back again

Sheila

> When I tried to merge custom formated date (mmmm dd, yyyy) from excel, the
> merged document is showing the date as number. How to have the date in the
> format i required. I am using Office 2003

Reply to this Message