Formula Saves In Cell But Does Not Compute
 

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.

Formula Saves In Cell But Does Not Compute
 

Check that the format is not text

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"roy.okinawa" wrote in message
...
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.

Formula Saves In Cell But Does Not Compute
 

Hi!

Those cells have been formatted as TEXT.

One way to fix:

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

Biff

"roy.okinawa" wrote in message
...
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.

Formula Saves In Cell But Does Not Compute
 

That was it.

Thanks.

"Peo Sjoblom" wrote:

Check that the format is not text

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"roy.okinawa" wrote in message
...
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.