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

[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?

 

[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

 

[JE McGimpsey]

Don't know what Help you checked, but this is in my version's help:

If number < -512 or if number > 511, DEC2BIN returns the #NUM! error
value.

Also, Dec2Bin takes a numeric first argument, not a text string.

See

http://www.mcgimpsey.com/excel/udfs/longdec2bin.html

convert the dec or hex to bin(16 BIT) <convert the dec or hex to