On Fri, 8 Jul 2005 14:28:01 -0700, "GeeB"
wrote:

I made a typo in my previous post...

This:
A5: =hex2dec(MID,A1,3,255))

Is actually this in my spreadsheet:
A5: =hex2dec(MID(A1,3,255))

Again, just a typo in the post. I used the correct formula in Excel and get
the error as noted.

Well, that's why I suggested copy/paste rather than typing it in :-))

In any event, there is an MSKB article that may relate to your problem,
assuming your formulas are accurate. See

http://support.microsoft.com/default...b;en-us;291058

I would also suggest to install both the Analysis Tool Pak and the Analysis
Tool Pak-VBA.

Finally, see if HEX2DEC shows up in the function list, when you hit the Fx
button next to the formula bar.


--ron