Excel 2002

Larry · Oct 31, 2003

How do you enter a hexidecimal number? I see several
functions that will convert to hex for decimal or octal,
but I already know what the number is in hex.

Biff · Oct 31, 2003

Hi Larry,

A HEX number can contain both alpha and numeric characters
and as such, XL considers that a *text* string.

1DD39 hex, would be interpreted as a text string
869 hex would be interpreted as numeric decimal 869

Just enter the hex value and if you need to perform
calculations on them then you have to convert them to
decimal using the HEX2DEC() function. After any calcs then
you could convert back to hex using DEC2HEX().

Biff