Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
About mail merge
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
About mail merge
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge | Excel Discussion (Misc queries) | |||
Code launches Mail Merge but disables the Mail Merge | Excel Discussion (Misc queries) | |||
mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
how do i get my mail merge to update the data source at each merge | Excel Discussion (Misc queries) | |||
mail merge | Excel Discussion (Misc queries) |