I have Excel 2000. No =hex2dec() in there, indeed it gives a #NAME error.
For myself I solved this with a simple DLL:
http://www.geocities.com/smplprgrsrc/files/HEX2DEC.zip

Probably not according to all conventions, but it works fine for me.




"GeeB" schreef in bericht
...
OK...this is probably a very simple answer, but I can't seem to find it...

I have a column of hexidecimal numbers (0x20, 0x40, etc.) that I want to
simply present the SUM of that colum in Hex. I've been unable to get the
SUM
function to do this. What am I missing?