Formulas won't enter into cells in Excel 2000 only as useless data
 

I have multiple worksheets on a file - where we use formulas with functions
to transfer data from one sheet to another. If I edit the formulas they are
replaced only as raw data and not a formula - and that applies to any formula
placed in the cell - it is not a matter of locking, or protection.

Formulas won't enter into cells in Excel 2000 only as useless data
 

1. clear the cell
2. pull-down
Format Cells... Number General
3. re-enter the formula

To check the procedure, touch CNTRL-~ several time. The cell should toggle
between formula and result.
--
Gary's Student


"rebelkey" wrote:

I have multiple worksheets on a file - where we use formulas with functions
to transfer data from one sheet to another. If I edit the formulas they are
replaced only as raw data and not a formula - and that applies to any formula
placed in the cell - it is not a matter of locking, or protection.