Hi, Tek-tippers! I am trying to reconcile a massive currency nightmare in an Excel workbook. However, some of the values I get (there are four sources) are not true currency numbers and have many decimal places, usually in the six to eight range.
If I format to currency, of course, it only *looks* like it's two decimal places. When I have a long column of these numbers, the total at the bottom can be off by up to 45 cents from the total if the decimal places are actually two.
Fixing it manually works, but is time-consuming.
Is there a way to actually round my data up to two decimal places without touching each cell?
Michelle Hakala
If I format to currency, of course, it only *looks* like it's two decimal places. When I have a long column of these numbers, the total at the bottom can be off by up to 45 cents from the total if the decimal places are actually two.
Fixing it manually works, but is time-consuming.
Is there a way to actually round my data up to two decimal places without touching each cell?
Michelle Hakala