DIFF SNAP issue

When i compare txt type files, everything works well with the DIFF snap but when i try to compare excel files, sometimes the column formats look different and it appears as a MODIFIED row on the report. Is there a trick to that? For example, a money field may look like a text formatted column from one system but in the other may be a number field. DIFF snap is throwing out those as modifications even though the amount is the same in both rows.