merge date into word from excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ramon Niese - 30 Aug 2005 16:02 GMT

Hi,

Don't know for sure if this is the right group to post but I will give it a
try.

I have an excel document that I want to merge into word. In this excel
document there is a field Date.
The date is displayed in excel as: 27-03-1995
If I merge this into word than the date is displayed as 03-27-1995.
Does anyone know what i must do to solve this?

thx in advance.

Ramon

Reply to this Message

Doug Robbins - 30 Aug 2005 20:21 GMT

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

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

and/or

See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi,
>
[quoted text clipped - 10 lines]
>
> Ramon

Reply to this Message

Rate this thread: