the cell currently being evaluated contains a constant

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

"Barrie Wells" <Barrie [email protected]> wrote in message
news:[email protected]...
> 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

Probably "entered", not "pasted"

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Niek Otten" <[email protected]> wrote in message
news:[email protected]...
> 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
>
> "Barrie Wells" <Barrie [email protected]> wrote in message
> news:[email protected]...
>> 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
>
>