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.