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
|
|||
|
|||
MAIL MERGE
I’ve done mail merge between word and Excel. I have data in excel that
should display in word document. I have typed some number say for example 300.63 But it’s displaying in word as 300.635530489733. Even though I have given two decimal place in excel, Its placing around more than 10 decimal places. I want only two decimal places in word. Do you have any idea?? Best regards Vishu |
#2
|
|||
|
|||
Debra Dalgleish posted this for a different question:
In the Mail Merge, after you select your Excel file as a data source, you should see a 'Confirm Data Source' dialog box. (If you don't see the dialog box, change the setting in Word -- under ToolsOptions, General -- add a check mark to 'Confirm Conversion at Open') From that list, choose 'MS Excel Worksheets via DDE (*.xls)', and your formatting will be retained. If you have to connect through a different source, you can format the fields in the Word document. For example, to specify a number of decimals: 1. In Word, in the Main Document, press Alt+F9 to view the field codes. 2. Find the field code for the number. It will look something like: { MERGEFIELD FieldName } 3. Add a switch, to format the number with two decimal places. For example: { MERGEFIELD FieldName \# "#,##0.00" } 4. Press Alt+F9 to hide the field codes. 5. Save the Main Document ========== An alternative. Use a helper cell with a fromula like: =text(a1,"#0.00") and use that in your mailmerge. vishu wrote: I’ve done mail merge between word and Excel. I have data in excel that should display in word document. I have typed some number say for example 300.63 But it’s displaying in word as 300.635530489733. Even though I have given two decimal place in excel, Its placing around more than 10 decimal places. I want only two decimal places in word. Do you have any idea?? Best regards Vishu -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using Hyperlinks in Mail Merge IF...THEN...ELSE Statements | Mark V | Mailmerge | 8 | November 30th, 2004 01:31 PM |
Customize a Mail Merge doc | Neh | Mailmerge | 1 | September 1st, 2004 12:47 AM |
Secured DB for a Word Mail Merge problem | Tony_VBACoder | General Discussion | 1 | August 30th, 2004 10:11 PM |
Secured DB for a Word Mail Merge problem | Tony_VBACoder | Mailmerge | 0 | August 30th, 2004 07:32 PM |
Mail Merge Problem | MT DOJ Help Desk | General Discussion | 9 | July 20th, 2004 04:55 AM |