Displaying Formulas

  • Thread starter Thread starter John
  • Start date Start date
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.
 
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
 
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.
 
Back
Top