Autosum and Manual Sum not working
Don't mean to too obvious but have you formatted the relevant cells to
currency ? If not, highlight the column or cells containing the data, right
click, Format Cells, Number, Currency then choose your currency and decimal
places.
--
Es
"Gaileen" wrote:
I want to simply add several rows in a column - all containing currency
formatted cells. No matter what I do the total always appears as "0.00". My
formula seems pretty straightforward: =SUM(G7:G135). I've researched this
for the past 2 hrs. and even had our IT people involved, but no seems to be
able to help. I have a fairly large spreadsheet and don't want to have to
revert to my calculator. Anyone?
|