MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.