| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula does not display the resulting value in the cell
I have a correct formula, but instead of getting the result displayed, I get
the formula. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
formula does not display the resulting value in the cell
Change the format in the cell with the formula to either general or a
number, press F2 and enter -- Regards, Peo Sjoblom "Liliana" wrote in message ... I have a correct formula, but instead of getting the result displayed, I get the formula. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
formula does not display the resulting value in the cell
Also check ToolsOptionsView and make sure that the Formulas box is
unchecked. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Peo Sjoblom" wrote in message ... Change the format in the cell with the formula to either general or a number, press F2 and enter -- Regards, Peo Sjoblom "Liliana" wrote in message ... I have a correct formula, but instead of getting the result displayed, I get the formula. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index and match formula resulting in #REF | Excel Worksheet Functions | |||
| Formula to convert resulting #N/A to 0 | Excel Worksheet Functions | |||
| Formula resulting in 0 | Excel Discussion (Misc queries) | |||
| HOW TO: In a formula, how to change the format of the resulting te | Excel Worksheet Functions | |||
| My formula show up in the cell instead of a resulting value | Excel Worksheet Functions | |||
Linear Mode
