Josh
Try    =Dec2Hex(a,b) where a = the number to convert & b = the size of the
output string ( I think).
Also I think it only works with integers!
- It may also depend on the version of Excell & what addins you have
applied.

Richard P





Hi all. I have a list of numbers in an Excel file in decimal format. I
would like to tranlate these numbers to hexadecimal format. Is there a
way to do that using Excel? It would save me doing the calculations
manually and reduce that source of error.

Thanks,

Josh
--
A common mistake that people make when trying to design something
completely foolproof is to underestimate the ingenuity of complete
fools.
        -Douglas Adams

--
http://www.piclist.com hint: PICList Posts must start with ONE topic:
[PIC]:,[SX]:,[AVR]: ->uP ONLY! [EE]:,[OT]: ->Other [BUY]:,[AD]: ->Ads

--
http://www.piclist.com hint: PICList Posts must start with ONE topic:
[PIC]:,[SX]:,[AVR]: ->uP ONLY! [EE]:,[OT]: ->Other [BUY]:,[AD]: ->Ads