Rather than deleting and re-typing, change the format to General then F2,
Enter


Gord Dibben MS Excel MVP

On Wed, 4 Feb 2009 16:16:02 -0500, "John" wrote:

Hi
The cell is formatted as text, delete the cell then go and format as
General.
Retype your formula.
HTH
John
"Gulfman100" wrote in message
...
I have a cell that will not accept a formula. I enter =B6 and the cell does
not return the value in B6 but returns the text =B6. This is the only cell
in
a multi sheet w Help wiorkbook that does this. What's going on? Help will
be
appreciated.

Thanks,
Gulfman