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