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?

"RJP" wrote:

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

Unfortunately I have tried this and it does not solve the problem


"DB Queen (Not)" wrote:

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?

"RJP" wrote:

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

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

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