When copy cell A1 contain ="1" and Paste Special (Value only) to cell B1,
cell B1 value= 1. Then i type 1 at cell A2.
I compare A2 with B1 and it show that B1 not equal with A2, but B1 equal to
A1.
But if i double click on the cell B1 and enter or click "convert to number".
The result will be reverse. May i know why?

A1 {="1"} ; B1 {copy cell A1 contain ="1" and Paste Special (Value only) to
cell B1}
C1 {=if(A1=B1,"Yes","No")}

A2{1}; B2{blank}; C2 {=if(A2=B1,"Yes", "No")}

Initial result: C1= Yes, C2=No
after double click on the cell B1 and enter or click "convert to number":
C1= No, C2=Yes


I have lots of cells, some with formula {="xxx"} and some without formula
{xxx}. How to convert all to the numbers by few steps?

Thanks in advance!