Displaying Formula Result Error

  • Thread starter Thread starter Shane
  • Start date Start date
S

Shane

When typing a formula, I cannot see the result.

I have tried ctrl + ~, however this just expands all columns. Thi
only seems to happen on some of my worksheets.

Any suggestions are grealtly appreciate. I have also tried searchin
for an similar question, but could not find one.

Thanks!!!

Shan
 
Shane

What do you see if not the result? The formula?

Possible that the cell was pre-formatted as Text.

Format to General and re-type the formula or hit F2<ENTER>

If you have a bunch of these, select the cells then Edit>Replace

What: =
With: =

Replace all.

Gord Dibben Excel MVP
 
Back
Top