I have an Excel sheet with percentages (11 decimals). The decimal sign is comma. See example below.
Year Period CostPercentage
2020 1 0,01800188
2020 2 0,016852519
But when I read the data in TX then I see the below result:
![](https://uploads-eu-west-1.insided.com/timextender-en/attachment/a64c8bc9-2c47-45df-a825-81cb0c017604.png)
I have tried to use the culture feature see below but no success. Find a screen dump below
![](https://uploads-eu-west-1.insided.com/timextender-en/attachment/d5c322fc-3e47-4335-866c-deefc42fbe0c.png)
Why does TX / Cdata not read the data as is? The “,” is interpreted as a Thousand separator.
Any help will be appreciated.
When I have a file with a “.” (dot) as a decimal sign I convert the data to numeric precision 38,scale 11 and that works.
Best answer by Lorenzo
View original