hex to decimal convert
 

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

On Sun, 16 Jan 2005 19:31:32 GMT, "Nadia" wrote:

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

Use

=HEX2DEC(A1)

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



In article ,
"Nadia" wrote:

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

Thank you Ron,
It works fine

Nadia


"Ron Rosenfeld" wrote in message
...
On Sun, 16 Jan 2005 19:31:32 GMT, "Nadia" wrote:

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

On Sun, 16 Jan 2005 20:24:25 GMT, "Nadia" wrote:

Thank you Ron,
It works fine

Nadia

You're welcome. Glad to help.

--ron