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
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 :
will display: 19.70{ Mergefield Cost \# "0.00" }
HTH
Carim
thanks......i will try that tomorrow at work!
i'm sorry . . im a noob.
when i go to data link properties there is no DDE link . . can you help me again????
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks