Exact Function

[Rhett C]

I'm trying to compare two columns of check numbers using the exact function
to get a true or false. One column of check numbers have zeros in front of
check number and second column does not have zeros, but the function is
resulting in a false due to it comparing the two as text and not number. I've
tried formatting the column to number but the zeros don't come off, any
ideas???

 

[Peo Sjoblom]

EXACT is a text function so it does what it is supposed to do. if your check
numbers are true excel numbers then you can compare them as A1=B1

Another possible way


=EXACT(TEXT(A1,"000000"),TEXT(B1:B10,"000000"))

where the number of zeros should be larger or equal to the total digits of
the checks that have leading zeros


If you copy and empty cell formatted as general or number with zero decimals
and then select the check numbers and do edit>paste special and select add
then you should be able to do a simple =A1=B1 comparison

--


Regards,


Peo Sjoblom