|
| 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
May 30th, 2006, 06:44 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
2.61 becomes 2.609999 when merging from Excel into Word.
2.61 becomes 2.609999 when merging from Excel into Word.
I have tried to re-format several ways in Excel (number, general, currency, etc). no luck...please help if familiar thanks in advance lou 
|
|
#2
May 30th, 2006, 09:04 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
2.61 becomes 2.609999 when merging from Excel into Word.
Try using a ROUND function in Excel. What you have now is simply changing
the display in Excel but not the underlying number which is 2.609999. -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! My criminal defense site: http://addbalance.com --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "Lou Griffith" Lou wrote in message ... 2.61 becomes 2.609999 when merging from Excel into Word. I have tried to re-format several ways in Excel (number, general, currency, etc). no luck...please help if familiar thanks in advance lou
|
|
#3
May 31st, 2006, 06:52 AM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
2.61 becomes 2.609999 when merging from Excel into Word.
Use a formatting switch - http://www.gmayor.com/formatting_word_fields.htm
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Lou Griffith wrote: 2.61 becomes 2.609999 when merging from Excel into Word. I have tried to re-format several ways in Excel (number, general, currency, etc). no luck...please help if familiar thanks in advance lou
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Why dont MS just f**king re-write Word from scratch? Its dogsh*t | Word Hater | General Discussion | 30 | January 7th, 2010 10:55 PM |
| Word should catalog misspelled words to study. | rndthought | General Discussion | 38 | January 23rd, 2008 11:53 PM |
| Converting WordPerfect 12 files to Word 2003 | Curious | New Users | 3 | March 29th, 2006 01:05 AM |
| Excel worksheet in Word linked text boxes | Eduardo Oliveira | Page Layout | 0 | January 5th, 2005 11:23 PM |
| Word 2000/2002 - Proper Mail Merge steps for ODBC? | Tony_VBACoder | Mailmerge | 7 | September 2nd, 2004 09:21 PM |
Linear Mode
