CONVERT not working

D

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?
 
P

Peo Sjoblom

Do you get TRUE if you do


=ISNUMBER(B1)

If you get FALSE you should get that error?
 
R

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.
 
Top