Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Lou Griffith
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Charles Kenyon
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor
 
Posts: n/a
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 97 in Windows XP to maintain formatting Charlie''s Word VBA questions Microsoft Word Help 22 May 20th 23 08:51 PM
Why dont MS just f**king re-write Word from scratch? Its dogsh*t Word Hater Microsoft Word Help 33 May 5th 23 02:52 PM
How to put graphics on envelopes? Steve Koenig Microsoft Word Help 21 April 29th 23 02:47 AM
take yet another lesson from wordperfect "reveal codes" wordperfect is superior Microsoft Word Help 5 May 11th 09 07:58 PM
Excel worksheet in Word linked text boxes Eduardo Oliveira Page Layout 0 January 5th 05 11:23 PM


All times are GMT +1. The time now is 05:29 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"