Sure, here's the basic column:

A1: 0x20
A2: 0x1
A3: 0x80

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

After entering the formula, the #NAME? appears in A5

I've also tried removing the '0x' portion of the #'s with the same result.

I'm running Excel 2003

Thanks for your assistance.

Copy and paste the exact formula you are using; and also copy/paste the exact
data it is working on.

Let's see if we can figure this out.


--ron