-
Excel Functions?
Does any body know how to add functions to Excel to convert different number systems, Binary to hex and octal... I haave tried add and Customize could not get it to work. Please post here if you know how or where to get more info on this. I am using Office 2K.
Thanks.
-
I've got O2K installed and Excel already has the 3 functions you mentioned: HEX2DEC, HEX2BIN and OCT2HEX. I haven't played with them, but I'm sure it would be simple enough to get any combination you need (ex: get OCT to DEC by doing OCT2HEX then HEX2DEC). If they don't appear on your system, make sure you've got the Analysis ToolPak installed (its an option when you install Excel). Once you've got it, you need to enable it under Tools, Add-Ins.
------------------
dcj2
[email protected]