why isn't hex2dec working?

Question

I just tried to use my old computer to make a quick table I can glance at in Excel for a little hexadecimal editing. Since I can't work directly with hex numbers I was using the dec2hex and hex2dec functions.

However, I keep getting #NAME? when I tried to use hex2dec. Even when copying directly from the example in the help.

What is going on?

Here's a screenshot:

Answer 1

Re:  Hex2Dec worksheet function

It is part of the MS add-in "Analysis ToolPak", which must be installed by the user in Excel 2003.

Find Add-Ins on the Tools menu.

'---

Jim Cone

Portland, Oregon USA

https://goo.gl/IUQUN2 (Dropbox)

(free & commercial excel add-ins & workbooks)

Answer 2

I don't remember having to check that every time. Was there a way to get it enabled by default, and a drawback to doing so (memory, CPU overhead, larger output files, etc)?

I thought I might have forgotten to install some optional component when I reinstalled everything from scratch (and backup) after a hard drive crash about a year and a half ago, but I just checked the box and it worked.

It has been a while since I've used hex in Excel however and while this is far from the first time I've used it on the old computer in the last ten years (longer if you count Excel 97 under Windows 98, I did say this was old and I was displaying the table on the old computer while I worked on the Windows 7 system), it is in another way of looking at things the first time I actually have done so on this hard drive. The install was about as clean as you can make it given that the "new" hard drive had to be partitioned and formatted after it had been DoD wiped.

Thanks.