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 :

{ Mergefield Cost \# "0.00" }

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