Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula displays as a formula, not as its result
Hi,
I am using excel 2007. I have a simple formula in a cell , the cell displays the formula, not its result. I have checked under excel options/advanced/worksheet, the option 'show formulas ....' is un checked. Formats are set to 'general' Help please ? Thanks KK |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula displays as a formula, not as its result
dido22 submitted this idea :
Hi, I am using excel 2007. I have a simple formula in a cell , the cell displays the formula, not its result. I have checked under excel options/advanced/worksheet, the option 'show formulas ....' is un checked. Formats are set to 'general' Help please ? Thanks KK Maybe... Did you change the cell format to "General" after you entered the formula? If so, select the cell, hit F2, hit Enter. The formula should now show a return value. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Displays Formula, not result | Excel Worksheet Functions | |||
Cell displays formula, not result? | Excel Discussion (Misc queries) | |||
Formula displays result in formula box but not in cell | Excel Discussion (Misc queries) | |||
Formula displays result in formula box but not in cell | Excel Worksheet Functions | |||
Cell displays formula and not result | Excel Discussion (Misc queries) |