Are you sure that 511 gets converted. BIN2HEX converts a binary number to
hex, so it can only consist of 0 and 1.

Also, =HEX2DEC("43E2") worked for me.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"pellis" wrote in message
...
BIN2HEX is acting really wierd. BIN2HEX(511) works fine. BIN2HEX(512)
returns a #NUM! error.

Also, can't figure out how to input a hex number into the worksheet. If I
input '43E2', the worksheet will NOT recognize this as a hex number. Is
there some type of indicator I need to use? Could not find ANYTHING in
the
help sections.