Thread
:
BIN2HEX function will convert '511', but not '512'
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
[email protected]
Posts: n/a
BIN2HEX function will convert '511', but not '512'
BUT 511 and 512 are DECIMAL's not binary numbers, so it shouldn't work
with EITHER - DEC2HEX would return a value. And 43E2 is translated to
17152 using HEX2DEC when typed normally onto my sheet.
Reply With Quote