| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas appear in cell as entered..
whatever function (eg. "=sum(A1:A10)") I typed into the cell, the formula
just appeared as normal text, displaying exactly what I typed in. how can I get it to work? I do not think this is due to the manual calculation update option, as it has been set to automatic.. any help is appreciated.. thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formulas appear in cell as entered..
Hi
Try pressing Ctrl +` (that's the Control button and the key above Tab and left of 1 -- Regards Roger Govier "GeneWan" wrote in message ... whatever function (eg. "=sum(A1:A10)") I typed into the cell, the formula just appeared as normal text, displaying exactly what I typed in. how can I get it to work? I do not think this is due to the manual calculation update option, as it has been set to automatic.. any help is appreciated.. thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formulas appear in cell as entered..
the cell is formatted as TEXT:format cell as General
"GeneWan" wrote in message ... whatever function (eg. "=sum(A1:A10)") I typed into the cell, the formula just appeared as normal text, displaying exactly what I typed in. how can I get it to work? I do not think this is due to the manual calculation update option, as it has been set to automatic.. any help is appreciated.. thanks! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formulas appear in cell as entered..
Gene, sounds like the cell is formatted as text, format to general or
something else and reenter the formula -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "GeneWan" wrote in message ... whatever function (eg. "=sum(A1:A10)") I typed into the cell, the formula just appeared as normal text, displaying exactly what I typed in. how can I get it to work? I do not think this is due to the manual calculation update option, as it has been set to automatic.. any help is appreciated.. thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel ignoring previously entered formulas | Excel Worksheet Functions | |||
| Auto calculate formulas when new data is entered | Excel Discussion (Misc queries) | |||
| Need cell formulas to return the day of every Monday in a month based on year entered | Excel Discussion (Misc queries) | |||
| #N/A Values : Returned by Formulas vs Entered Manually | Charts and Charting in Excel | |||
| Formulas returning a blank if no data entered in one cell | New Users to Excel | |||
Linear Mode
