In column AJ I have numbers formatted as general which come from a formula. For example AJ3 = =IF(BJ3>Y3,L3,LEFT(AM3,FIND("-",AM3,1)-1)) which results in "1".

In column L I have numbers formatted as general which also come from a formula. For example L3 = =OFFSET(Table2[@Quantity],-1,0,1,1) which results in "1".

However, when I write a formula to compare the two, AJ3=L3 it says false. Why is this? I have tried formatting them as numbers, text, general, all to the same result. I don't get it!

Any help would be awesome.

Thanks!