software

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.

Check that the format is not text

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon

quot;roy.okinawaquot; gt; wrote in message
...
gt; For some reason in parts of my spreadsheet when I type a formula in a cell
gt; and save it, the formula text will save and show in the cell, but the
gt; actual
gt; formula calculations will not work.
gt;
gt; Help.Hi!

Those cells have been formatted as TEXT.

One way to fix:

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

Biff

quot;roy.okinawaquot; gt; wrote in message
...
gt; For some reason in parts of my spreadsheet when I type a formula in a cell
gt; and save it, the formula text will save and show in the cell, but the
gt; actual
gt; formula calculations will not work.
gt;
gt; Help.
That was it.

Thanks.

quot;Peo Sjoblomquot; wrote:

gt; Check that the format is not text
gt;
gt; --
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Northwest Excel Solutions
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;roy.okinawaquot; gt; wrote in message
gt; ...
gt; gt; For some reason in parts of my spreadsheet when I type a formula in a cell
gt; gt; and save it, the formula text will save and show in the cell, but the
gt; gt; actual
gt; gt; formula calculations will not work.
gt; gt;
gt; gt; Help.
gt;
gt;