Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mail merge with attachments | Mailmerge | |||
Mail merge using an excel file | Microsoft Word Help | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge | |||
Include linked graphs from Excel during mail merge? | Mailmerge | |||
Mail merge error occurs when filtering Excel data source | Mailmerge |