Problem with data from cells in merge fields

C

caryd

Overview:
I have merge document set up to merge with my spreadsheet.

The cells I want it to merge with have been formatted as a percentage
with 3 decimal places. When I merge the cells into my document,
however, it is giving me a number like this 7.748000558954E-2 instead
of 7.75%.

What am I doing wrong?

Thanks

Cary D
 
A

aidan.heritage

Excel might be FORMATTED to show 3dp, but it still contains 15dp - try
using formatting codes in your merge fields to get the format correct
 

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

Merge Problems 1
using images in a mail merge 2
merging text and data fields without loosing zeroes ie .00l 3
Excel Word Mail Merge 8
Mail Merge from Excel Spreadsheet 1
Mail Merge Formating Issues 3
Using Excel values in Word Mail Merge 3
Currency format lost when merging into Word 1

Top