Hello.
I am trying to mailmerge a word document using data from an excel
spreadsheet. Despite the spreadsheet being formatted to English dates
(dd-mmmm-yy) and numbers to 0 decimal places when the documents merge the
dates show as American (mm/dd/yy) and the figures to 10 decimal places. I
have checked my system is set up in English format but am unaware of what
else can be done.
Any ideas.
Thanks.
RP
Have you tried going into the control panel and regiional options and date
and making sure that the default date setting is dd-mm-yy?
> Hello.
>
[quoted text clipped - 10 lines]
>
> RP
RJP - 08 Apr 2005 12:27 GMT
Unfortunately I have tried this and it does not solve the problem
> Have you tried going into the control panel and regiional options and date
> and making sure that the default date setting is dd-mm-yy?
[quoted text clipped - 13 lines]
> >
> > RP
Usually you can solve these things if you use the DDE connection method - in
Word 2002/3 check Tools|Options|General|"Confirm conversion at open", go
through the connection process again, and select the DDE option when
offered.
Otherwise, try using Alt-F9 in Word to view the raw fields and change, e.g.
{ MERGEFIELD mydate }
to
{ MERGEFIELD mydate \@"DD//MM/YYYY" }
and
{ MERGEFIELD mynumber }
to something like
{ MERGEFIELD mynumber \#0 }
There is more in Graham Mayor's article at
http://www.gmayor.com/formatting_word_fields.htm
If you can't get the month and date to appear in the right order using
\@"DD/M/YYYY", it is probably because of a problem in the OLEDB provider
that Word is probably using to get the data. The DDE approach should solve
that, but at one point Microsoft offered a fix - you would have to contact
their Customer Support Services for more info. on that.
Peter Jamieson
> Hello.
>
[quoted text clipped - 10 lines]
>
> RP
RJP - 11 Apr 2005 08:29 GMT
Your first suggestion has worked a treat and all is now fine for both the
dates and numbers.
Thank you for taking the time to suggest the solutions.
Regards.
> Usually you can solve these things if you use the DDE connection method - in
> Word 2002/3 check Tools|Options|General|"Confirm conversion at open", go
[quoted text clipped - 43 lines]
> >
> > RP