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.
"Peter Jamieson" wrote:
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
"RJP" wrote in message
...
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