ExcelBanter - Formulas Displaying-Excel 2007

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formulas Displaying-Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/197998-formulas-displaying-excel-2007-a.html)

denilynn

Formulas Displaying-Excel 2007

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?
--
Thanks in advance for your time!
denilynn

Nat

Formulas Displaying-Excel 2007

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

Hope that helps

"denilynn" wrote:

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?
--
Thanks in advance for your time!
denilynn

Bob Umlas, Excel MVP

Formulas Displaying-Excel 2007

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)

"denilynn" wrote:

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?
--
Thanks in advance for your time!
denilynn

All times are GMT +1. The time now is 04:26 AM.