instead of forula result I see formula

  • Thread starter Thread starter Barb
  • Start date Start date
B

Barb

Hi everybody.
I hope somebody can help me.
Some cells in my worksheet are showing formula itself, not
the result of that formula. I tried formatting cells as
text, numbers - but I can't get the result of the formula.
And it's not the whole worksheet, only specyfic cells.
Any ideas?

Barb
 
Format-Cell-protection- remove the check on hidden.
However you will have to copy a cell where the formula
works- onto these cells.
HTH
 
Barb

The cells were pre-formatted as Text. Re-formatting will not change that.

Select all cells by CRTL + A. Set Format to General. Then with all cells
still selected...........

Edit>Replace

what: =
with: =

Replace All and your formulas should not be showing. Results should show.

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
Back
Top