06-27-2019 11:46 AM
Hi there,
I am using excel file to read the sheet and i am noticing that it is truncating decimals. It reads the formatted column values instead of the actual values…
for example … Value: -123.943661971831 is read as -$123.94
Whereas i want the actual value not the formatted.
08-29-2019 02:51 PM
@dgupta The Excel Parser Snap now has a new property “Cell formatting” starting with Snap Pack version transform7780 and is available as latest in the UAT and production environments. Setting the property to “Unformatted” should solve your issue.