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
|
|||
|
|||
Merge data into word document form Excel, large signific number
When I merge data into a word document from an excel data sheet, I sometimes
get and excess of signficant number into the merged feild. For example when I entered the number 7.8 in the excel data sheet the merged number in the wrd dcument become 7.7999999999999998. How do I prevent this from happening? Thanks |
#2
|
|||
|
|||
Merge data into word document form Excel, large signific number
See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at http://www.gmayor.com/formatting_word_fields.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "ecoeng" wrote in message ... When I merge data into a word document from an excel data sheet, I sometimes get and excess of signficant number into the merged feild. For example when I entered the number 7.8 in the excel data sheet the merged number in the wrd dcument become 7.7999999999999998. How do I prevent this from happening? Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
insert Excel data into Word Mail Merge document | RRemy | Mailmerge | 2 | June 25th, 2005 04:52 PM |
How to change merge forms from Word Perfect to Microsoft Word | Charles Kenyon | General Discussion | 1 | December 30th, 2004 03:35 PM |
Merge data from Excel into different docs in one Word file | sue_w1231 | Mailmerge | 1 | November 16th, 2004 12:55 AM |
Word 2000/2002 - Proper Mail Merge steps for ODBC? | Tony_VBACoder | Mailmerge | 7 | September 2nd, 2004 09:21 PM |
Macro help please: Excel data to word doc | anna-maria | General Discussion | 5 | June 30th, 2004 11:53 PM |