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