Reply
 
Thread Tools Display Modes
  #1   Report Post  
Marisa
 
Posts: n/a
Default How do I change the date format to a long date after merging it

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)?
  #2   Report Post  
Doug Robbins - Word MVP
 
Posts: n/a
Default How do I change the date format to a long date after merging it

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/cindy...r/MergFram.htm


--
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

"Marisa" wrote in message
...
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)?



  #3   Report Post  
Marisa
 
Posts: n/a
Default How do I change the date format to a long date after merging it

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

"Marisa" wrote:

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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change the default date format in AutoText? tturner33 Microsoft Word Help 2 October 18th 05 05:45 PM
How do I change the date display in the comments pane. frogmouth Microsoft Word Help 2 August 4th 05 02:57 AM
Mail Merge date format problem with Word 2003 Thang New Users 1 May 2nd 05 01:55 PM
date format change when using serial printing Paulo Merieles Microsoft Word Help 3 January 5th 05 12:24 AM
Mail Merge - Date Format Kilinski Microsoft Word Help 0 December 7th 04 01:13 PM


All times are GMT +1. The time now is 04:48 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"