Convert to Binary and Break out results

There is DEC2BIN function available? Where is it (I'm getting a #NAME?
error
when I try your formula)?

I see you figured it out. I have 2007 and had forgotten that Dec2Bin was
part
of the ATP.

I, too, have had occasions where restarting Excel re-enabled the ATP. No
idea
why, either.

That is the first time ATP ever went out on me (that I am aware of at
least). I thought I had remembered DEC2BIN as a function even though I never
had an occasion to use it before, but when I checked for it and didn't see
it, I figured I was remembering wrong. Anyway, the restart seems to have
straightened everything out although I would love to know what I did (or
what took place on my system) to knock it out.

Rick