About mail merge

  • Thread starter Thread starter mns
  • Start date Start date
M

mns

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date format changes in mail merge using Excel worksheet as data 2
Excel 2002: How to make the date format uniform ? 1
date 1
Convert dates stored as text 2
Date Formats 1
Formatting Dates from Text to Numbers 2
Date format to Text Date for use in Mail Merge 3
Date automatically swaps 6

Back
Top