[Jason]

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

[Peter Jamieson]

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

[Jason]

Many thanks for your help this has solved my problem

"Peter Jamieson" wrote:

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