How to resolve discrepancy between compensation model summary and exported excel total amount?

Summary:

How to resolve discrepancy between compensation model summary and exported excel total amount?

Content (required):

While creating a merit model, total amount displayed in the summary table slightly varies from the total amount calculated when we export the same data in excel. Oracle support mentioned that they do not control the rounding rule in exported file, as this is not part of their application but belongs to Excel features. How do we make sure that the value calculated from excel is same as summary total amount? What should be the settings in excel so as the value is same?