Formula going troppo
We have a spreadsheet with the usual numbers to be added (eg:
=SUM(A2:A59)with the total showing in cell A60.The problem we are having is
when we double click in the total cell (A60) the total turns to 0. I have
checked the calculation tab in the tools options and it is set on auto. We
cannot understand when there is a number there eg: $8512.30 and we double
click in the cell to check our formula it changes to $0.00 and the only way
you can get your number back is via the undo button.
|