Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 97 in Windows XP to maintain formatting | Microsoft Word Help | |||
Why dont MS just f**king re-write Word from scratch? Its dogsh*t | Microsoft Word Help | |||
How to put graphics on envelopes? | Microsoft Word Help | |||
take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
Excel worksheet in Word linked text boxes | Page Layout |