Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
whub3 whub3 is offline
external usenet poster
 
Posts: 2
Default merging times from excel into word

I am trying to merge swim team times (mm:ss.00) to a word document. I keep
getting different results no matter how many times I try to format the times.
I have tried text, numbers and custom times (like above).
An example is a freestyle time of 33.33 comes out as 33.3299999999 when its
merged. The field is formatted as text. Same thing when the field is
formatted as numbers with 2 decimel points.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default merging times from excel into word

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"whub3" wrote in message
...
I am trying to merge swim team times (mm:ss.00) to a word document. I keep
getting different results no matter how many times I try to format the
times.
I have tried text, numbers and custom times (like above).
An example is a freestyle time of 33.33 comes out as 33.3299999999 when
its
merged. The field is formatted as text. Same thing when the field is
formatted as numbers with 2 decimel points.



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
whub3 whub3 is offline
external usenet poster
 
Posts: 2
Default merging times from excel into word

Thanks for your help.

The answer was to revert back to DDE for data exchange. Set the "ask" in the
options menu for data exchange.

"Doug Robbins - Word MVP" wrote:

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"whub3" wrote in message
...
I am trying to merge swim team times (mm:ss.00) to a word document. I keep
getting different results no matter how many times I try to format the
times.
I have tried text, numbers and custom times (like above).
An example is a freestyle time of 33.33 comes out as 33.3299999999 when
its
merged. The field is formatted as text. Same thing when the field is
formatted as numbers with 2 decimel points.




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 12:38 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"