exporting to word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

annette redlin - 25 Mar 2004 10:00 GMT

I am trying to mail merge in word using excel spreadsheet
as data fields. Trouble is what appears in s sheet
doesn't appear in word e.g. in s sheet may be 3.90 - in
word becomes 3.8999999991 and 3.60 becomes 3.6. Have
setting as numbers with 2 decimal places. Have tried
currency etc. but makes no diference. Help!

Reply to this Message

Bill Manville - 26 Mar 2004 01:20 GMT

Annette redlin wrote:

> Trouble is what appears in s sheet
> doesn't appear in word e.g. in s sheet may be 3.90 - in
> word becomes 3.8999999991 and 3.60 becomes 3.6. Have
> setting as numbers with 2 decimal places.

There is a difference between the value held in a cell and the value
displayed when that cell is given a particular number format.
Word is seeing the value held in the cell.

You could probably force the value in the cell to be what you want by
using a formula, either

=ROUND(A2,2)
or
=TEXT(A2,"0.00")

where you replace A2 by the formula that is currently in the cell or by
a reference to a cell containing the value that you were previously
using.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Reply to this Message

David McRitchie - 26 Mar 2004 21:37 GMT

Hi Annette,
Be sure to have your Excel spreadsheet as the first worksheet tab in your workbook.
To alleviate formatting problems such as with currency so you use what you see in Excel:
In the Confirm Data Source dialog box,
click the MS Excel Worksheets via DDE (*.xls), and then click OK.

Mail Merge, Printing Labels using Mail Merge with data from Excel
http://www.mvps.org/dmcritchie/excel/mailmerg.htm--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Reply to this Message