I hope you mean that 8.95 is displaying as 8.94999999999993 or 8.94 is
displaying as 8.9399999999999993, because then you can try using Alt-F9
to show the field code, let's say it is
{ MERGEFIELD mynumber }
or
{ MERGEFIELD mynumber \*Mergeformat }
then change it to
{ MERGEFIELD mynumber \#£0.00}
or
{ MERGEFIELD mynumber \#£,0.00}
if you want thousands separators.
Peter Jamieson
http://tips.pjmsn.me.uk
Visit Londinium at
http://www.ralphwatson.tv
On 08/10/2009 18:34, Jason wrote:
Hi
I am using word and excel 2003 when doing a mail merge from excel I have a
field that is for a monetary value i.e £8.94, the excel sheet has been
formated to 2 decimal place.
When its merged to word the field outputs the following £8.9499999999999993.
Can any one advise how to format this correctly.
Thanks