Hex to Dec and Oct to Dec..... 1

[flaniganmj]

Howdy,

Is there a built in function, or even an add-in, to allow me to convert hexadecimal to decimal, i.e. 5F to 95? I also need to convert Oct to Dec. Any help is greatly appriciated.

flan

 

[TonyJollans]

Hi flanpk,

There are functions which I think are a standard part of VBA to do all this ..

Hex(number) converts a number to hexadecimal
Oct(number) converts a number to octal
CDec(number) converts a number to decimal

In all the above, number can be
- a decimal number
- a hex literal given as &H followed by a hex number
- an octal literal given as &O followed by an octal number
- a String which translates as one of the above

Enjoy,
Tony