Dollar Amounts Changing

[chrisg]

This is a very strange problem, and I don't know where the formattin
issue is. I am attempting to mail a number of letters where peopl
obviously owe different dollar amounts. If they owe an amount out t
two decimal places, such as $141.16, it prints correctly. However,
have one customer that owes $494.50, and it prints as $499.00. I hav
another customer that owes $698.10, and it prints as $699.00. Wha
gives? Any account that does not have a number in the hundredth
amount adds a seemingly random amount and it prints as a full dolla
figure.

My merge field is set up as:

{MERGEFIELD "Owed" \#$#,##0.00 } and I am using Word and Excel 2000 Pr

 

[Cindy M -WordMVP-]

Hi Chrisg,

A wild guess, here: In Excel, is the column with these amounts formatted
as "currency"? If you change it to a regular number does the problem
disappear in Word?

This is a very strange problem, and I don't know where the formatting
issue is. I am attempting to mail a number of letters where people
obviously owe different dollar amounts. If they owe an amount out to
two decimal places, such as $141.16, it prints correctly. However, I
have one customer that owes $494.50, and it prints as $499.00. I have
another customer that owes $698.10, and it prints as $699.00. What
gives? Any account that does not have a number in the hundredths
amount adds a seemingly random amount and it prints as a full dollar
figure.

My merge field is set up as:

{MERGEFIELD "Owed" \#$#,##0.00 } and I am using Word and Excel 2000 Pro

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail