| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Is there way to enter multiple values into excel cells w/ a form? | Excel Discussion (Misc queries) | |||
| Excel should let me use formulas that refer to other cells w/ form | Excel Worksheet Functions | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Linear Mode
