Why doesn't this work?

[ScottInTexas]

I thought it was simple, but I get a #Num! error.
=DEC2BIN(1024,10)
At first I used a reference =DEC2BIN(T6,10) but that gave the error, so I used a value for the number.

The syntax is exactly what is shown in the documentation. I am doing something wrong and can't see it.

 

[Fluff]

Dec2bin does not handle numbers above 511, try using Base instead.

 

[ScottInTexas]

Dec2bin does not handle numbers above 511, try using Base instead.

Thank you for your reply.

What about in VBA? Size restrictions there too? If I am in VBA and want to use a 10 bit value, to turn on the tenth bit I have to OR 512 with 0 to get 1000000000 (512). To turn that bit off I have to AND it with 511. Every bit except that one will retain it's value. But since I get an overflow error I am thinking, this too, is not allowed.

 

[Fluff]

Did you try using the BASE function?

 

[ScottInTexas]

Never mind. I had a stupid moment. My variable needed to be long and I wasn't paying close enough attention.

 

[Fluff]

Glad you sorted it & thanks for the feedback.