"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?