sorry, I haven't study your solution, will try later.

but for Ron's solution, I can also edit one cell and paste to the rest of
the same row/column of cells.

Thanks.

"Peo Sjoblom" .gbl...
So if you had 200 cells that were like that you would go through each of
them? My method will do it in one fell swoop

--

Regards,

Peo Sjoblom

"ah 3" wrote in message
...
Ron Coderre has given the answer and tested good. Thanks anyway.

"Peo Sjoblom"
l...
Maybe the workbook is becoming corrupt?
Anyway you can select all formulas and do editreplace and replace the
equal
sign with the equal sign to trigger a calculation before you do that
make
sure all formats are not text since if you format a cell as text you
will
see the formula and not the result

--

Regards,

Peo Sjoblom




"ah 3" wrote in message
...
yes, but I am sure this is not the cause of the problem. Thanks.

"Bob Phillips"
bl...
Check ToolsOptionsView and make sure that Formulas is not checked.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ah 3" wrote in message
...
Hello all,

I encountered problem for some excel files when typing a formula
but
displayed a formula instead of its calculated values, e.g.

when I entered "=100 + 100", what I exepected is to display as
"200",
but
it
was displayed as "=100 + 100" instead.

Please kindly help, many thanks!