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.


"GeeB" wrote:

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