| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula won't display as cell set to Constant
I'm am having an issues with Excel 2002 - SP3 (XP)
I occasionally come across an issue where a formula won't display the value. I.e - cell displays =N3-N4 rather than the answer. Using the watch window I can see =N3-N4 is displayed in the text column rather than the formula column. Also the evaluate formula tool tells me that the cell is displaying a constant. Please help! Thanks Laurence |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula won't display as cell set to Constant
If the cell is displaying the formula, it could be because the cell format is
TEXT. Check format and change to GENERAL if required and re-enter formula. "Laurence J" wrote: I'm am having an issues with Excel 2002 - SP3 (XP) I occasionally come across an issue where a formula won't display the value. I.e - cell displays =N3-N4 rather than the answer. Using the watch window I can see =N3-N4 is displayed in the text column rather than the formula column. Also the evaluate formula tool tells me that the cell is displaying a constant. Please help! Thanks Laurence |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what symbol should i put in the formula to make a cell constant? | Excel Discussion (Misc queries) | |||
| How do I keep one cell constant in a formula even when copying | Excel Discussion (Misc queries) | |||
| How do I set one cell as a constant so I can drag the formula | Excel Discussion (Misc queries) | |||
| keep a cell used in a formula constant when pasteing into another. | Excel Worksheet Functions | |||
| keep a cell used in a formula constant when pasteing into another. | Excel Worksheet Functions | |||
Linear Mode
