View Single Post
  #5  
Old September 16th, 2004, 01:52 PM
external usenet poster
 
Posts: n/a
Default

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.

.