If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
exporting to word
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! |
#2
|
|||
|
|||
exporting to word
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 |
#3
|
|||
|
|||
exporting to word
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 |
Thread Tools | |
Display Modes | |
|
|