Displaying Formula Result Error

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
 
G

Gord Dibben

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
 
Top