To convert your data to numbers. Copy the range.Right clickPaste
SpecialValues OK. Still if you have any issues with the numbers

--Copy a blank unused cell. Select the range of cells you want to convert.
Right clickPasteSpecialAdd. click OK

If this post helps click Yes
---------------
Jacob Skaria


"HS Yong" wrote:

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!