Someone can help me on troubleshooting this problem, please?

I'm importing a CSV file (separated by semicolon) from OneDrive to a Zoho Reports Table.

Everything runs smoothly but I have a problem with currency and decimal columns.

I have a decimal value in the CSV that is 2,5  (comma for decimal)

Scenarios:

1 - I've defined the taget column as Decimal, with two decimal places, and a comma as a decimal separator. The importing result are:

for 2,6 in the source the result is 26,00

for 1 in the source the result is 1,00 (correct)

for 2,74 in the source, the result is 274,00

it seems that the importing task is not reading the comma in the file and just adds two decimal zeros to any number.

2 . I've defined the target column with dot separator, or with no decimal places, all the possibilities given in the decimal format, but the result is allways wrong. The importing process is not reading the separator comma in the source file.

The importing will be an automatic task, so I'm will not be able to change the source file manually everyday. I need to use it as it is.

Someone can help me with a solution that does not need to edit the source file?

Thanks