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
 
Top