Excel to word merge

[Arvi Laanemets]

Hi

To use Excel table as a source for MS Word Mail Merge, better create a
special table for it, where all numeric and date values are replaces with
strings. I.e. when in your original table the date was p.e. in cell B5 on
sheet Data, then in new table in cell B5 you have the formula
=TEXT(Data!B5,"dd/mm/yyyy")

 

[Patsy Rogge]

Hi

We are trying to do a merge from Excel to Word in Office 2003. The date
format we need is DD/MM/YYYY. In Excel it displays correctly, but as soon
as you merge to word, it swops the format around to MM/DD/YYYY. It also
swops the format around in the Excel file at that point. We have checked the
regional settings and everything is correct.

Has anyone got any ideas???

Thanks

 

[Bruce Sinclair]

Hi

To use Excel table as a source for MS Word Mail Merge, better create a
special table for it, where all numeric and date values are replaces with
strings. I.e. when in your original table the date was p.e. in cell B5 on
sheet Data, then in new table in cell B5 you have the formula
=TEXT(Data!B5,"dd/mm/yyyy")

Other possibility is to make sure you get the data via DDE. The other
options certainly give other formating problems.



Bruce

----------------------------------------
I believe you find life such a problem because you think there are the good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)