I thought that might be the case; however, I have the Analysis ToolPak
add-in checked on my system and I am getting the #NAME? error. Any idea why
that may be happening?

Rick


"Peo Sjoblom" wrote in message
...
Analysis ToolPak

--


Regards,


Peo Sjoblom

"Rick Rothstein (MVP - VB)" wrote in
message ...
There is DEC2BIN function available? Where is it (I'm getting a #NAME?
error when I try your formula)?

Rick


"Ron Rosenfeld" wrote in message
...
On Wed, 27 Aug 2008 12:16:05 -0700, DCLittlejohn
wrote:

I would like to take a 16-bit integer value, convert it to binary and
then
break the individual 1s and 0s into seperate columns.

For example, a value of 5 in column A to break out into columns C,D,E,F
as
0,1,0,1 respectivly.

I need to be able to use the individual 1s and 0s later in the sheet.

A1: 5
C1: =MID(DEC2BIN($A$1,4),COLUMNS($A:A),1)

Fill right to F1



--ron