or clng, etc.

On Thu, 28 Aug 2003 10:22:34 +0100, "Keith Willshaw"
wrote:


"Markus Früh" wrote in message
...
hello

thanks for the link. but there is no help. they write about a function
called HEX2DEC() , but i do not have such a function? i have installed all
"add-ins" but my excel2000 (german) do not find this function?

has anybody an other solution?

thanks
markus



Sorry I misread your post

The function you need is

Variant=CDEC("String")

Where String is the hex number prefixed with &H

Thus

MsgBox CDec("&HC1A")

would output 3098

Keith