error when I try to convert hex to bin with more than 8 chacters?

  • Thread starter convert the dec or hex to bin(16 BIT)
  • Start date
C

convert the dec or hex to bin(16 BIT)

=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?
 
D

Dana DeLouis

=dec2bin("5600",16) will return #NUM?
I check the help it should work fine?

Hi. According to Help...
"...If number < -512 or if number > 511, DEC2BIN returns the #NUM! error
value."

Also, your number should not be the string "5600".
ie...=DEC2BIN(500,10)

One would think that with a "Major" release of Excel 2007, such a limitation
would have been updated. But...no!

--
HTH :>)
Dana DeLouis
Windows XP & reluctantly using Office 2007


"convert the dec or hex to bin(16 BIT)" <convert the dec or hex to bin(16
BIT)@discussions.microsoft.com> wrote in message
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top