Comparing two excel

Am comparing two excel files. In one excel file one column value as 1.00 , comparing this with another excel file it has column value like 1, logically it rights, but it gives doesnt matched.
What data type should i give it to it???

Hi @Bakia_Murugesan

convert either the 1.00 to integer or the 1 to a double

That should allow you to match the files

1 Like


Cdbl(row1(“ColumnName”).Tosting) = Cdbl(row2(“ColumnName”).Tosting)


Thank you …Its working @lakshman

1 Like

Hi @Bakia_Murugesan

Here is a detailed article on that :slight_smile: