Thread: BIN2HEX function will convert '511', but not '512'
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pellis
 
Posts: n/a
Default BIN2HEX function will convert '511', but not '512'
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.
Reply With QuoteReply With Quote