the cell currently being evaluated contains a constant

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Probably "entered", not "pasted"

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
You must log in or register to reply here.

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

Is there a function that will evaluate a text string in a cell? 2
Function to evaluate function as string 3
Doing a countif against a substring of the range to be scanned 1
How do I evaluate whether a character is present in a cell? 4
Excel considers my formulas as plain text 9
How do I fix: cell won't calculate because it is a constant? 1
Mapping integers to strings 5
evaluate a concatenate expression 3

Back
Top