Formula think thy're text!

[Hsibbs]

I have the following formula :
=IF(AND($K50>=clients!$D$5,$K50<=clients!$C$5+clients!$D$5),clients!$A$5, "")
If I prss F2 to edit it, when I press enter, it is no longer a formula, excel thinks it is text, and it appears as above?!?!
Has anyone come acroos this before? Does anyone know why it is?
Non of the other formulas on the (very large) spreadsheet do this, they all work fine!

 

[Richard Schollar]

Have you checked that the cell number format is not set to Text?

Best regards

Richard

 

[Hsibbs]

That was it! Thank you.

 

[Hsibbs]

That was it! Thank you.

 

[Avatar]

You've probebly already looked and tried this, but make sure your formula bar is present, then select the cell and look to see if there is a single quotation at the beginning of the formula infront of the equals. would look like this:

'=<FORMULA>

It would not show in the cell when you look at it.