B
BrownsFan
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?
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?