Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
FORMULA TROPPO LUNGA DI EXCEL | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |