| 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 |
| 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 | |||
Threaded Mode
