the cell currently being evaluated contains a constant

B

Barrie Wells

Excel generates the message:
"the cell currently being evaluated contains a constant"
and then does not evaluate a formula. The same formula, character for
character, works fine in a different workbook. I can find no differences
between their properties.
1) Does anyone know what causes this?
2) Does anyone know why there is no reference to this message in any
Microscoft help or assistance, although the message is generated by Excel?
Thanks,
Barrie
 
N

Niek Otten

You probably pasted the formula in a text cell.
Format as general (or number or whatever) and re-enter the formula (F2,
Enter)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
N

Niek Otten

Probably "entered", not "pasted"

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 

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

The cell currently being evaluated contains a constant 1
How do I fix: cell won't calculate because it is a constant? 1
Cell values not being properly evaluated by VLOOKUP() orSUMPRODUCT()... why? 1
cell currently being evaluated contains a constant 2
Embedding excel formula in MS Query that will be evaluated in excelnot in the SQL server 0
"the cell currently being evaluated contains a constant" 1
Is there a function that will evaluate a text string in a cell? 2
Formula/worksheet error 1

Top