How do I change the date format to a long date after merging it

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marisa - 30 Oct 2005 19:42 GMT

I have an Excel spreadsheet which I use for date input, I then import this
into Access database. Now I am trying to merge certain query info into a Word
document. However, the date format comes in as the US type (mm/dd/yyyy). I
have checked that it is in long date format in both Excel and Access but it
still displays incorrectly when I insert the merged field. Is there a way to
get the date to display as long format (30 October 2005 instead of
10/30/2005)?

Reply to this Message

Doug Robbins - Word MVP - 30 Oct 2005 21:59 GMT

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

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

and

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

>I have an Excel spreadsheet which I use for date input, I then import this
> into Access database. Now I am trying to merge certain query info into a
[quoted text clipped - 6 lines]
> get the date to display as long format (30 October 2005 instead of
> 10/30/2005)?

Reply to this Message

Marisa - 31 Oct 2005 16:15 GMT

Thank you, Cindy's web site really helped - it's working really well now!
Regards from Qatar

> I have an Excel spreadsheet which I use for date input, I then import this
> into Access database. Now I am trying to merge certain query info into a Word
[quoted text clipped - 3 lines]
> get the date to display as long format (30 October 2005 instead of
> 10/30/2005)?

Reply to this Message