Reply
 
Thread Tools Display Modes
  #1   Report Post  
Beth
 
Posts: n/a
Default Mail Merge - Excel Percentage changes

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??
  #2   Report Post  
Peter Jamieson
 
Posts: n/a
Default

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
"Beth" wrote in message
...
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
Mail merge using an excel file Liberty Microsoft Word Help 1 February 16th 05 03:11 PM
Mail Merge Issue With Office 97 - Excel Data Source Matt Thorley Mailmerge 1 February 15th 05 11:38 PM
Include linked graphs from Excel during mail merge? dhschick Mailmerge 1 December 14th 04 01:02 AM
Mail merge error occurs when filtering Excel data source Dave Mailmerge 1 December 2nd 04 10:46 PM


All times are GMT +1. The time now is 01:47 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"