Formula not reading a blank cell properly

[sobrien1234]

I have a formula that says if a cell= "" then "" - for example if in cell C1 I had the following =if(A1="","",B1)

The problem is it is not reading cell A1 as being blank even though it appears to be empty. It is in "general" format. The weird thing is it was working a few days ago but now it isn't.

Suggestions?

 

[fhqwgads]

check if formula calculations are automatic in the formulas tab>calculation options
or maybe try double click on a cell and see if it goes away

 

[Fluff]

What do these 3 formluae return
=ISBLANK(A1)
=LEN(A1)
=CODE(A1)