2.61 becomes 2.609999 when merging from Excel into Word.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lou Griffith - 30 May 2006 18:44 GMT

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 to this Message

Charles Kenyon - 30 May 2006 21:04 GMT

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.

Signature

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.

> 2.61 becomes 2.609999 when merging from Excel into Word.
> I have tried to re-format several ways in Excel (number, general,
[quoted text clipped - 4 lines]
> thanks in advance
> lou

Reply to this Message

Graham Mayor - 31 May 2006 06:52 GMT

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

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> 2.61 becomes 2.609999 when merging from Excel into Word.
> I have tried to re-format several ways in Excel (number, general,
[quoted text clipped - 3 lines]
> thanks in advance
> lou

Reply to this Message

Rate this thread: