software

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,quot;dd/mm/yyyyquot;)--
Arvi Laanemets
( My real mail address: arvi.laanemetslt;atgt;tarkon.ee )
quot;Patsy Roggequot; gt; wrote in message
...
gt; Hi
gt;
gt; We are trying to do a merge from Excel to Word in Office 2003. The date
gt; format we need is DD/MM/YYYY. In Excel it displays correctly, but as soon
gt; as you merge to word, it swops the format around to MM/DD/YYYY. It also
gt; swops the format around in the Excel file at that point. We have checked
gt; the
gt; regional settings and everything is correct.
gt;
gt; Has anyone got any ideas???
gt;
gt; Thanks
gt;
gt; --
gt; Patsy Rogge
gt;
gt;
gt;
gt;
gt; --
gt; Patsy Rogge
gt;
gt; 012-420 7240
gt; 012-420 7230
gt;
gt;
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

--
Patsy Rogge

--
Patsy Rogge

012-420 7240
012-420 7230
In article gt;, quot;Arvi Laanemetsquot; gt; wrote:
gt;Hi
gt;
gt;To use Excel table as a source for MS Word Mail Merge, better create a
gt;special table for it, where all numeric and date values are replaces with
gt;strings. I.e. when in your original table the date was p.e. in cell B5 on
gt;sheet Data, then in new table in cell B5 you have the formula
gt;=TEXT(Data!B5,quot;dd/mm/yyyyquot;)

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)