Displaying Formulas

J

John

I have a workbook with 3 worksheets. On all three
worksheets, when any formula is entered, the result is the
formula. For example, in cell A1 I enter "=B1", the result
should be the contents of B1. But what is displayed
is "=B1". If I add a 4th sheet and enter the above
formula, it works correctly. It is just something in the
spreadsheet info that is preventing the formula from
working correctly.
 
F

Frank Kabel

Hi John
the cell is porbably formated as text. Goto 'Format - cell' and change
the format to 'General'. Reenter your formula and it should work

Frank
 
R

RagDyer

Two things:

Either the column was formatted as TEXT *before* the formula was entered
OR
<Tools> <Options> <View> tab,
Under WindowOptions,
The "Formula" box is checked.

If it's the first cause, simply changing the format to General or Number
will *not* work.
After correcting the format, select the "bad" formula cell, click in the
formula bar, and just hit <Enter>.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have a workbook with 3 worksheets. On all three
worksheets, when any formula is entered, the result is the
formula. For example, in cell A1 I enter "=B1", the result
should be the contents of B1. But what is displayed
is "=B1". If I add a 4th sheet and enter the above
formula, it works correctly. It is just something in the
spreadsheet info that is preventing the formula from
working correctly.
 
Top