Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cells show formula like in formula bar, rather than result of form
hi - i must have hit a setting somehow as all new formulae i enter into
excel, do not return the result of the formulae - they just return the formulae itself (e.g. =e1). Existing formulae are not displayed so it's not a ctrl + ` issue! any help appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
cells show formula like in formula bar, rather than result ofform
Perhaps the cells with the new formulae in are formatted as Text.
Format them as General, then F2 followed by <Enter to bring about the change in format. Hope this helps. Pete On Dec 18, 4:17*pm, James Irwin wrote: hi - i must have hit a setting somehow as all new formulae i enter into excel, do not return the result of the formulae - they just return the formulae itself (e.g. =e1). Existing formulae are not displayed so it's not a ctrl + ` issue! any help appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
cells show formula like in formula bar, rather than result of form
It sounds like the cells have been formatted as text.
Select the offending range format|cells|Number tab|general (or anything but text) and reenter the formula. Or You could be looking at formulas. In xl2003: Tools|Options|view tab|uncheck formulas James Irwin wrote: hi - i must have hit a setting somehow as all new formulae i enter into excel, do not return the result of the formulae - they just return the formulae itself (e.g. =e1). Existing formulae are not displayed so it's not a ctrl + ` issue! any help appreciated. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using the result of formula as part of reference to a cell in form | Excel Worksheet Functions | |||
Why does the formula show instead of the result? | Excel Discussion (Misc queries) | |||
Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
My formula will not show the result, only the formula. | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |