Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I display the RESULT of a formula
I enter "=1+1" in a cell. Instead of displaying 2, what is displayed is
"=1+1" (without the quotes). I go into microsoft help, do a search on "display formla", it has a section "display or hide formulas", it has "switch between displaying formulas and their values on a worksheet". I click that and it says: Press CTRL + (grave value) I have no idea what "grave value" means. I've already wasted an hour on this. HELP!!!! |
#2
|
|||
|
|||
Hi
It may be that the cell was formatted as text before you entered the formula. Format it as General and re-enter the formula. The grave accent is ` which is to the left of 1 on my keyboard. -- Andy. "Poor microsoft user" <Poor microsoft wrote in message ... I enter "=1+1" in a cell. Instead of displaying 2, what is displayed is "=1+1" (without the quotes). I go into microsoft help, do a search on "display formla", it has a section "display or hide formulas", it has "switch between displaying formulas and their values on a worksheet". I click that and it says: Press CTRL + (grave value) I have no idea what "grave value" means. I've already wasted an hour on this. HELP!!!! |
#3
|
|||
|
|||
Thank you Andy! I changed the formatting of the cell, it didn't help.
However, after I changed the formatting of the cell, I RE-ENTERED the formula, and then it worked. I tried entering CNTL (grave symbol), it didn't help. I spent 45 minutes reading microsoft "help", and found nothing about the goofy way formatting cells as text before entering a formula will cause the formula to not function. Thanks again! "Andy B" wrote: Hi It may be that the cell was formatted as text before you entered the formula. Format it as General and re-enter the formula. The grave accent is ` which is to the left of 1 on my keyboard. -- Andy. "Poor microsoft user" <Poor microsoft wrote in message ... I enter "=1+1" in a cell. Instead of displaying 2, what is displayed is "=1+1" (without the quotes). I go into microsoft help, do a search on "display formla", it has a section "display or hide formulas", it has "switch between displaying formulas and their values on a worksheet". I click that and it says: Press CTRL + (grave value) I have no idea what "grave value" means. I've already wasted an hour on this. HELP!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a formula result that will not appear on a chart | Charts and Charting in Excel | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
Formula Result Correct but value in the cell is wrong | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |