hex to decimal convert

[Nadia]

Hi
Is it possible to have a formula convert a string of hex values to decimal
numbers?
say put hex values, in column A1- A8
and as soon as you put in values in each cell
Dec numbers will apear adjcent B1-B8?

Hex ie: C0, 7E, 4D, F4, 1E, 4F, 55, 7D

and give the answers in

Dec ie: 192, 126, 077, 244, 030, 079, 085, 125

I hope this is clear, I am quite new to Excel

TIA

 

[Ron Rosenfeld]

Hi
Is it possible to have a formula convert a string of hex values to decimal
numbers?
say put hex values, in column A1- A8
and as soon as you put in values in each cell
Dec numbers will apear adjcent B1-B8?

Hex ie: C0, 7E, 4D, F4, 1E, 4F, 55, 7D

and give the answers in

Dec ie: 192, 126, 077, 244, 030, 079, 085, 125

I hope this is clear, I am quite new to Excel

TIA

Look at HEX2DEC in Excel Help.

Briefly, in B1 you would put the formula

=IF(A1="","",hex2dec(A1))

and copy/drag it down.


--ron

 

[JE McGimpsey]

Use

=HEX2DEC(A1)

HEX2DEC is an Analysis Toolpak Add-in function (Tools/Add-ins... check
the appropriate checkbox).

 

[Nadia]

Thank you Ron,
It works fine

Nadia

Look at HEX2DEC in Excel Help.

Briefly, in B1 you would put the formula

=IF(A1="","",hex2dec(A1))

and copy/drag it down.


--ron

 

[Ron Rosenfeld]

Thank you Ron,
It works fine

Nadia

You're welcome. Glad to help.

--ron