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
|