need help w/ mail merge excel to word

I'm having trouble with my numbers when merging from excel to word. my numbers are merging with two decimal places but when it merges onto word, the decimal carries 7 places. example 19.70 merges to 19.699999999 ????????

Please help!!!!!!


Thanks

Hi,

You are probably using a ODBC connection which "forgets" the format, whereas with a DDE link, everything would be fine ...

HTH
Carim

I should have added as an alternative to changing the connection, that you can always, within Word, add formatting switches to your field codes ...

For example :

Please Login or Register  to view this content.

will display: 19.70

HTH
Carim

thanks......i will try that tomorrow at work!

Should work out fine ...

Carim

i'm sorry . . im a noob.
when i go to data link properties there is no DDE link . . can you help me again????

Thanks

Hi,

Forget about the connection types ...
Go to Word and add formatting switches to your field codes ...

HTH
Carim

what does that mean

Hi,

We are in an Excel Forum .. so I will not expand on Word ...
Open Word
and from menu select Insert Field MailMerge ... and follow instructions
to replicate example I already gave you ...

HTH
Carim