|Here's my best shot:|
Format as Accounting, 2 Decimal places, $ symbol.
Format as Number, Zero Decimal places.
Format as Custom Format, Zero Zero.
In Column A, enter regular Dollar amounts.
In Column B, enter the formula
In Column C, enter the formula
Your sheet should now look somthing like:
$ 123.45 _____ 123 ___ 45
$1,234.50 ___ 1234 ___ 50
$ 987.00 _____ 987 ___ 00
$ 987.60 _____ 987 ___ 60
$ 123.01 _____ 123 ___ 01
For the Totals:
In Column A enter the forumla
In Column B enter the formula
In Column C enter the formula
(NOTE: This is the same formula as the regular cell)
The only two columns that actually get summed are
Column A which has the original dollar amounts and
Column B, because we have to carry over the dollars from the cents column.
In column C, instead of trying to sum then cut & paste, I just multiplied the remainders, calculated using =MOD(), by 100 to make them whole dollars and used the Custom Format to get rid of the pesky decimal points.
It worked for the amounts displayed.
My brain is now mush......