ATP loaded, =convert() remains lowercase

[dindigul]

I have the Analysis toolpak loaded, but still the function =convert()
remains in lowercase and gives #value. I checked the number with ISNUMBER()
and indeed i got a numerical value. ATP is loaded otherwise it would not
have recognised the function as such. What could be wrong?

 

[EeOr]

what are you trying to convert? Can you show the full formula?

Jon

 

[Bob Phillips]

You workbook doesn't have its own convert UDF by any chance?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[dindigul]

I tried this to convert from Fahrenheit to Celsius & all such things
supported by CONVERT. But Excel acknowledges it as a function as it does not
return #NAME as error instead it says "#VALUE". I type the function name in
caps, but it remains in lowercase indicating it is not accepting. I even
tried the statement given in Excel help file, copied ditto onto worksheet,
but same result =convert(68,"F","C"). I fail to understand why is this
happening?

 

[Dave Peterson]

Just some more thoughts that Bob spurred:

Or a range name (or any other name) called convert.

Or a module named convert?

I couldn't duplicate the problem with either of those two, but I've seen strange
things when I do things like this.

And a wild guess about something I don't use at all:

Do you use tools|options|calculation tab|allow labels in formulas?

Maybe it's looking for some table with a label of convert???

 

[Dana DeLouis]

For debugging, can you do the following, which is also an ATP function
(assuming a prior version to Excel 2007)

=DEC2BIN(100)
Does it work on a "new" workbook?

 

[dindigul]

Thanks Dana, first I got the answer as 1100100 and then suddenly it worked,
convert got into uppercase and problem solved. I don't know what triggered
it but Excel seemed to mend its ways. Thanks again