2.61 becomes 2.609999 when merging from Excel into Word.

[Lou Griffith]

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

 

[Charles Kenyon]

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




--------- --------- --------- --------- --------- ---------
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.

 

[Graham Mayor]

Use a formatting switch - http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>