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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top