Put it in quotes; "1000"

If the issue is that it is calculated, then you can coerce it to text, as in
=calc&""

Alternately, you can coerce Dec2Bin(8) to a number, as in
=Dec3Bin(8)+0

Jerry

"EvilTony" wrote:

"Jerry W. Lewis" wrote:

Excel doesn't see them as equal because the number 1000 is not the same as
the character string "1000".

Jerry


I can see that, but how do I stop Ecel seeing the 1000 as a number?
When I format the cell as text the formula still returns a "No", indicating
that the text-string 1000 is not the same as the Dec2Bin(8).

What I am asking for is
A) what format does Excel see a cell as when it holds a Dec2Bin output?
B) how can I make a numerical value equate to a Dec2Bin output?