Mail Merge - Excel Percentage changes

[Beth]

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??

 

[Peter Jamieson]

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