Dear LazyWeb: Excel Question

So, a friend has posed this query which I'm now opening up to my LazyWeb as well:

I use Excel a lot at work, managing revenue coming in and going out. Occasionally, Excel will round numbers in such a way as to cause financial errors.

Here is the latest example: $1080.90 * .35 = 378.315 and 1080.90 - 378.315 = 702.585. No problem. HOWEVER, if these numbers are formatted as currency or accounting, Excel rounds them and the result is this: 1080.90 * .35 = 378.32 and 1080.90 - 37.32 = 702.59 which is incorrect at the bank. So, my question is how does one manage this rounding in Excel to prevent this sort of error?

Thanks for any help/tip/suggestions!

Music Music Music!!!

I'm back from another great Pagan Jug Band show. Got to hang out s'more w/ferociousbcycad, which is always fun...and made even more so b'c he had some suggestions on fixes for some of my on-going 'puter/stereo/iPod/music-related issues/questions.

It's late now though and I'm gonna be up at 4:??am to head out (lvg by 5am) for b-fast w/lightfoote in Olympia before caravaning to help fae_raven move. Must sleep soon, even as the bounciness of great live music and the possibility of resolving music/tech issues keeps tempting me to stay up 'til way too late. I will NOT give in...