When I receive an Excel (with an Spanish format) the decimal numbers are separated from the rest by commas (,) (For example: 34,56) . The problem is that when UiPath reads the Excel he changes it for a dot (.) (For example: 34.56).
Is there anyway to change the UiPath configuration in a way that he reads the table with the spanish format?
This also happens with dates.
For example: 20/12/2018 (Spanish format) to 12/20/2018 (English format)
I usually correct the fields using replaces and changing order of digits in the case of dates, but I want to know if there’s an easiest way using the UiPath configuration.
Thanks in advance,