Financial Numbers not properly adding
 

When adding a column of numbers that are formatted as "accounting" and
to two decimal places, I'm getting an incorrect total. It's only off
by 1 cent, but I can't figure out why. When I copy the value and
paste it as a value only in another cell, I do notice that the number
is actually carried out to 10 decimal places. How do I prevent this?

Financial Numbers not properly adding
 

take a look this site

http://www.mcgimpsey.com/excel/pennyoff.html


"BrownsFan" wrote:

When adding a column of numbers that are formatted as "accounting" and
to two decimal places, I'm getting an incorrect total. It's only off
by 1 cent, but I can't figure out why. When I copy the value and
paste it as a value only in another cell, I do notice that the number
is actually carried out to 10 decimal places. How do I prevent this?