Hi there,
I am using excel as a db and pulling data to Word to print some labels. In
my excel file there is a date column which takes date values like DD/MM/YYYY
correctly but when this date come to Word unfortunetly it loses its format
and it becomes MM/DD/YYYY

any suggestions to this problem? thanks

Usually when such things get transferred to Word they'd just appear as a
date serial number, but there are at least 2 ways to tackle it.
In Excel, use a helper column =TEXT(A2,"dd/mm/yyyy")
Or use the field formatting commands in Word
http://word.mvps.org/FAQs/MailMerge/index.htm [The latter also discusses
the different way in which you can interface between Excel & Word to address
such problems.]
--
David Biddulph

"mns" wrote in message
...
Hi there,
I am using excel as a db and pulling data to Word to print some labels. In
my excel file there is a date column which takes date values like
DD/MM/YYYY
correctly but when this date come to Word unfortunetly it loses its format
and it becomes MM/DD/YYYY

any suggestions to this problem? thanks