| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I fix: cell won't calculate because it is a constant?
When I export a table from a third party application into an Excel file,
formulae are not calculated. The formulae are displayed instead of the value of the formula. I do not have this option selected (to display formulae instead of values). When I "evaluate formula" the message says that "The cell currently being evaluated contains a constant." |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I fix: cell won't calculate because it is a constant?
If the formula appears in both the formula bar and the cell, the problem is
usually that the cells have been formated to Text. Clear the cell, format it to General, and re-enter the formula. -- Gary''s Student - gsnu200822 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| text in a cell invoke constant date in another cell - how | Excel Discussion (Misc queries) | |||
| How can I remove a constant from a cell? | Excel Worksheet Functions | |||
| How do I add a formula to a cell containing a constant value | Excel Discussion (Misc queries) | |||
| Constant cell | Excel Worksheet Functions | |||
| the cell currently being evaluated contains a constant | Excel Worksheet Functions | |||
Linear Mode
