merging times from excel into word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

whub3 - 11 Aug 2006 03:08 GMT

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

Doug Robbins - Word MVP - 11 Aug 2006 04:38 GMT

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

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

Signature

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

>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
[quoted text clipped - 4 lines]
> merged. The field is formatted as text. Same thing when the field is
> formatted as numbers with 2 decimel points.

Reply to this Message

whub3 - 11 Aug 2006 23:09 GMT

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.

> See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
> website at
[quoted text clipped - 9 lines]
> > merged. The field is formatted as text. Same thing when the field is
> > formatted as numbers with 2 decimel points.

Reply to this Message