Prev: Count Blank Cells & Letter P
Next: Counting consecutive numbers in a list
From: Jazz on 11 Jan 2010 17:08
I put a formula in a worksheet and instead of making the calculation the
formula is showing. I checked Tools/Options/View but Formulas is not checked
off. Also Tools / Options / Calculation is set to automatic. Do you know
why this is happening
From: Jazz on 11 Jan 2010 17:11
Just figured it out. The cells I was having trouble with were locked. Thank
you.

"Jazz" wrote:

> I put a formula in a worksheet and instead of making the calculation the
> formula is showing. I checked Tools/Options/View but Formulas is not checked
> off. Also Tools / Options / Calculation is set to automatic. Do you know
> why this is happening
 | 
Pages: 1
Prev: Count Blank Cells & Letter P
Next: Counting consecutive numbers in a list