Formula Saves In Cell But Does Not Compute

R

roy.okinawa

For some reason in parts of my spreadsheet when I type a formula in a cell
and save it, the formula text will save and show in the cell, but the actual
formula calculations will not work.

Help.
 
P

Peo Sjoblom

Check that the format is not text

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon
 
B

Biff

Hi!

Those cells have been formatted as TEXT.

One way to fix:

Select the cells in question
Goto Edit>Replace
Find what: =
Replace with: =
Replace All

Biff
 
Top