Thanks 1,000,000 Anne & Doug for the assistance - you saved me from going bald.

"Anne Troy" wrote:

Try this, Colin:
http://www.officearticles.com/word/m...osoft_word.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Colin in RSA" wrote in message
...
I have create a word document using an Excel worksheet as my database. The
date format in the worksheet is dd/mm/yyyy but comes out as mm/dd/yyyy
using
the sql query function or yyyy/mm/dd if the data source is ODBC. How do I
get
the format I require with out making the 'date field' in the worksheet a
text
field??