I have an "=" sign in the beginning and also set the
format to "General". Also, the same formula works in
another worksheet.
-----Original Message-----
Oops, hit send too fast...
If you *have* and = sign before (A1*2), then your cells
are formatted as
Text. Format them as General and reenter the formulae.
In article ,
wrote:
I have an excel workbook that I converted from text.
When
I create formula in a cell (A1*2) it just displays the
formula and not the result. I checked the options and
it
is not set to display formula.
.
|