When I import this item via
IMPORTXML and the spreadsheet locale is US (or other country that uses dot as decimal separator) it works fine:
When I set the locale to Brazil, for example, it understands this dot as a thousand separator and imports the number as
1.000.000.000 (the source
My problem is that I need to deal with both numbering format.
I have checked this question already, but the proposed solutions didn't work. Any ideas? So far I had to create a separated spreadsheet to deal with both formats, but it'd be good if IMPORTXML wasn't that clever trying to figure out what's the data format.