CONVERT not working

[dindigul]

I loaded the Analysis pack addin, typed 100 in B1, in B2 typed =CONVERT(B1,
"F", "C") and I get #VALUE, no matter what I do. I changed number format
also but of no avail. What's wrong?

 

[Peo Sjoblom]

Do you get TRUE if you do


=ISNUMBER(B1)

If you get FALSE you should get that error?

 

[dindigul]

I get True, now what?

Do you get TRUE if you do


=ISNUMBER(B1)

If you get FALSE you should get that error?

 

[Roger Govier]

Hi

With ATP loaded, and 100 entered in B1, I get a result of
37.77778

If I unload the ATP, then I get a #VALUE result.

Check again that you do have ATP loaded, then edit the cell and press
RETURN.