Viewing the decimal places in Excel

Situation:

We are having trouble viewing the decimal places of the "Qty" column in Adeptia Mapper's Data Viewer (and in turn the output data). Every cell under "Qty" has 5+ decimal places, and yet Adeptia's data viewer only shows 2 places

 

Solution:

This setting needs to be done in the excel workbook/file to increase or decrease the number of Decimal places in a particular data filed.

In your file the current Decimal Places set for column "Qty" is 2 and that can be further increased as per your requirement. Adeptia will then parse that number of decimal places data coming from the excel worksheet.

 

 

Have more questions? Submit a request

0 Comments

Article is closed for comments.