Formula will not calculate


Posted by Paul on October 08, 2001 2:18 AM

When I type a formula in a cell in column B it shows as a formula, will not calculate, all other cells on the sheet work fine. Please help. Thanks

Posted by Juan Pablo on October 08, 2001 7:15 AM

The cell is probably formatted as Text, format it as General, edit the formula and it should calculate.

Juan Pablo



Posted by Paul on October 08, 2001 7:58 AM

Thanks Juan That was it.