hex to decimal convert

  • Thread starter Thread starter Nadia
  • Start date Start date
N

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
 
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
Click to expand...

Look at HEX2DEC in Excel Help.

Briefly, in B1 you would put the formula

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

and copy/drag it down.


--ron
 
Use

=HEX2DEC(A1)

HEX2DEC is an Analysis Toolpak Add-in function (Tools/Add-ins... check
the appropriate checkbox).
 
Thank you Ron,
It works fine

Nadia


Ron Rosenfeld said:
Look at HEX2DEC in Excel Help.

Briefly, in B1 you would put the formula

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

and copy/drag it down.


--ron
Click to expand...
 
Back
Top