Thread: error when I try to convert hex to bin with more than 8 chacters?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
convert the dec or hex to bin(16 BIT) convert the dec or hex to bin(16 BIT) is offline
external usenet poster
  
Posts: 1
Default error when I try to convert hex to bin with more than 8 chacters?
=dec2bin("5600",16) will return #NUM?
I check the help it should work fine?
I was using the hex2bin function too and it behaves same.
How should I convert the dec or hex to bin with more than 8 bits?

Reply With QuoteReply With Quote