Home |
Search |
Today's Posts |
#1
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
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
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 97 in Windows XP to maintain formatting | Microsoft Word Help | |||
Why dont MS just f**king re-write Word from scratch? Its dogsh*t | Microsoft Word Help | |||
How to put graphics on envelopes? | Microsoft Word Help | |||
take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
Excel worksheet in Word linked text boxes | Page Layout |