How do I fix: cell won't calculate because it is a constant?

W

wvc

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."
 
G

Gary''s Student

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel won't resolve formula in one column 3
A "relative" absolute cell reference? 6
Displaying results in formula bar when cell is hidden 1
Formula won't display as cell set to Constant 1
HOW DO I MULTIPLY MANY CELLS BY A CONSTANT CELL ? 12
How do i assign a null value to a cell in Microsoft Excel? 1
Carry data from sheet to sheet automatically 2
how can we make one constant number to be act as variable 3

Top