Mail Merge - Excel Percentage changes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Beth - 15 Apr 2005 16:41 GMT

As most people here I've been doing merges for quite some time. When I use
my existing Excel spreadsheet as the data source for my Word document it is
now converting all percentage numbers (i.e, 0.26% becomes 2.59999999901%).
I'm really confused...any help out there??

Reply to this Message

Peter Jamieson - 16 Apr 2005 14:54 GMT

What changed, if anything? Did you change your version of Word? Which
version are you using? And if it is Word 2002/2003 have you tried either

Use a numeric format switch, e.g. use Alt-F9 to view the field codes and
change

{ MERGEFIELD mypercentage }

to

{ MERGEFIELD mypercentage \#"0.00%" }

or check Word Tools|Options|General|"Confirm conversions at open", go
through the process to connect tot your data source again, and select DDE
when offered.

Peter Jamieson

> As most people here I've been doing merges for quite some time. When I
> use
> my existing Excel spreadsheet as the data source for my Word document it
> is
> now converting all percentage numbers (i.e, 0.26% becomes 2.59999999901%).
> I'm really confused...any help out there??

Reply to this Message

Rate this thread: