Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
hplfoghorn hplfoghorn is offline
external usenet poster
 
Posts: 1
Default How do I format a future date in english format?

Please help,

I have been set a huge project by my RM & I am mail merging from an excel
spreadsheet to a letter. I have a future date set up in my Spreadsheet & am
trying to get it to merge accross in the correct (British) format. I can
successfully get the date into the word document automatically, but it shows
in mm/dd/yyyy. I need it to show as dd/mm/yyyy. Can anyone help please as I
am on a tight deadline?

Many Thanks in advance.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default How do I format a future date in english format?

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

"hplfoghorn" wrote in message
news
Please help,

I have been set a huge project by my RM & I am mail merging from an excel
spreadsheet to a letter. I have a future date set up in my Spreadsheet &
am
trying to get it to merge accross in the correct (British) format. I can
successfully get the date into the word document automatically, but it
shows
in mm/dd/yyyy. I need it to show as dd/mm/yyyy. Can anyone help please as
I
am on a tight deadline?

Many Thanks in advance.



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
The date in a merged word doc is US format source is UK format Cogito Mailmerge 4 March 12th 08 01:28 PM
fax templates are in USA date format not English how do I change JSPA Microsoft Word Help 1 January 11th 08 10:03 AM
Date format in English JohnDav Microsoft Word Help 1 April 7th 06 04:48 PM
US / English date format mailmerge Bento72 Mailmerge 1 February 7th 06 01:57 PM
How do I keep English date format when using mail merge? Johnc Mailmerge 2 July 29th 05 06:11 PM


All times are GMT +1. The time now is 02:09 PM.

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

About Us

"It's about Microsoft Word"