"Himu" <Hi...@discussions.microsoft.com> wrote in message
news:E40F29E6-4C74-438F...@microsoft.com...
--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=22181
View this thread: http://www.excelforum.com/showthread.php?threadid=389266
> no, for large numbers DEC2BIN functions dont work. Any other suggestions?
Sure it does, you just have to work a little harder.
=DEC2BIN(INT(n/256),8)&DEC2BIN(MOD(n,256),8)
However, 65536 = 2^16, so you need 17 bits to represent it, as in
=DEC2BIN(INT(n/256),9)&DEC2BIN(MOD(n,256),8)
Jerry