Formulas Displayed

I've run into a problem with formulas remaining displayed under a variety of conditions, referencing cells in worksheets in the same workbook, referencing cells in other workbooks, adding "if" statements to a formula, etc.

The only solution I have come up with so far is to delete the entire workbook and start again from scratch, crossing my fingers the entire time.

Re: Formulas Displayed

I'm not sure if this is your problem, but sometimes I inadvertently hit 'Ctrl'+ ~ (usually to the left of the '1' key across the top of the keyboard - do not use the shift key) which toggles the display formulas mode.
Hitting 'Ctrl'+ ~ again should toggle the display back to normal (or go through Tools>Options>View and uncheck 'Formulas'

Re: Formulas Displayed

Press Alt-F11 to open the VBE, view the Project Explorer if it isn't showing (Ctrl-R). If there are modules for this workbook, click + in the left-hand window to see if they contain code. Then click + for Excel Objects, and doubleclick "ThisWorkbook" to see if there's any Workbook-level code. Finally doubleclick each sheet you are using to see if there's any Sheet-level code. Close VBE with the upper left "x".

Re: Formulas Displayed

Does this happen in all your workbooks or just some or one in particular. ? Also are all cells affected, or do any formulae show results. And excuse me for asking but have the = sign in front of all the formulae ?

Re: Formulas Displayed

The problem appears to be that the cells with the formulas are formatted as 'Text', they should be formatted as 'General' even if they are linking to a text cell.

If the cell is formatted as 'Text', and you already have a formula in the cell, changing the format to 'General' won't automatically fix the problem. You'll need to highlight the cell, the press the 'F2' key, then hit enter to correct the formula.