How do I format a future date in english format?

[hplfoghorn]

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.

 

[Doug Robbins - Word MVP]

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


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