Thanks Peter, wasnt my post but solved my issue from earlier!

Peter Jamieson Wrote:
The simplest way to revert to previous behaviour is generally to check
Word|Tools|Options|General|Confirm conversion at Open, re-connect to
your
Excel data source and choose the DDE option when offered. I suspect you
must
have been using that in Word XP as you would probably be having the
same
problems.

Alternatively, you can use "formatting switches" in the fields, e.g.
use
Alt-F9 to show

{ MERGEFIELD mynumber \*Mergeformat }

and change it to

{ MERGEFIELD mynumber \#0.00 }

(you can leave the Mergeformat in there if you want)

The formats are documented in Word Help.

Peter Jamieson
"John Richmond, Watford UK" John Richmond, Watford
wrote in message
...
In producing reports by mailmerge from Excel into Word, an Excel cell
holding
a calculated value formatted to display as 3.45 will be shown as
3.449993782999200000. Even cells carefully formatted to integers e.g
3
will
often transfer to 3.0000000000000001. Percentages such as 78% get
transferred as 0.798745300322220 Only if the values have been typed
in
will
the mail merge show the correct number.

This did not happen with previous versions of Word and Excel, where
the
number was transferred as formatted in Excel. Is there any way of
putting
this right?

Versions in use are Word 2002 SP3 and Excel 2002 SP3




--
Capt_Trips