Formulas Displaying-Excel 2007

D

denilynn

My formulas are showing up in some of my cells (not all cells though). I have
gone into Excel Options/Advanced/unchecked show formulas, etc. Any ideas?
 
N

Nat

Have you tried going into the cells you want to hid the formulas in and
choosing format cells>Protection>hidden? After doing this you have to either
protect teh sheet or the workbook before the formulas are hidden.

Hope that helps
 
B

Bob Umlas, Excel MVP

The cells MAY be formatted as text. Ctrl/1, Number tab will tell you. if
that's so, reformat (General?) and re-enter the formula (F2/Enter)
 
Top