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

G

Guest

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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Re: Convert Array Formulas to Regular Formulas 0
Making an excel sheet so formulas can not be deleted in the sum to 2
Counting # of Formulas in a column with formulas and entered data 1
Excel 2007: Insert Row into Defined Area & Inherit Above Formulas 4
Formula results display only after pressing Enter key 1
Lookup Tables and Formulas 1
move a row of data from one work sheet to another using a formula 1
Macros to cells, formula only not data locked 4

Top