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

=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
wrote in message
...
=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?

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

In article ,
convert the dec or hex to bin(16 BIT) <convert the dec or hex to
bin(16 wrote:

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