convert hex-values to decimal values

[Markus Früh]

hello everybody

i need a function to convert hex-values to deciaml-values (excel 2000)

example:
hex2dec("5A") -> result: "90"


who can help me?
thanks
markus

 

[Wild Bill]

http://www.experts-exchange.com/Applications/MS_Office/Q_20658588.html

 

[Markus Früh]

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

 

[Wild Bill]

Now that I look at it more closely I see a lot of noise there. Try the
code in routine Button1_Click there and see if you can adapt that logic.

 

[Keith Willshaw]

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?

The inbuilt function is Hex(no)

Keith

 

[Wild Bill]

http://www.aboutvb.de/khw/artikel/khwhextodec.htm no doubt Good.
I didn't realize that Val had that capability - but it's right there in
its help.

 

[Wild Bill]

or clng, etc.

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