Excel percent format does not come through in mailmerge

S

Sue Lohmann

Hi,

I am extracting data from a very old DOS program. I have
converted it to an Excel sheet and formatted two columns
as percentages. The numbers come in as 0 for 0% and 1 for
100% and I want the percentages to appear in my merged
document. This was not a problem in Word 2000, but when I
upgraded to Word XP and attach the file, the percentages
do not appear. I can do it by going into Access and
formatting the fields, but the people I support do not
know Access. I have experimented with various things in
Excel but can't get the formats to appear in the merge.
Any ideas?
Thanks, Sue
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Menu Macro Not Executing - Need Help 1
Excel does not accept text format! 0
Table of content - format does not get saved 2
Template with fields and premade texts.. 0
Merging from an Excel file with graphics 1
Grouping {MERGEFIELD} into 2 or 3 Columns 0
Percent Help 2
Integrating information from Word to Excel (not mail merge) 1

Top