CODEWITHSUNDEEP
google-sheetsnumber-formattinggoogle-sheets-formula
Santiago Abbracciavento
Santiago Abbracciavento

Reputation: 39

Convert to double from IMPORTXML in google sheets

When I use the IMPORTXML function it retrieves me a text of a double with other format and I want to convert it to double.

I'm getting

1.258,00

But I want to convert it to

1,258.00

Otherwise google sheets doesn't recognize it as a double (I can't use the =VALUE() because of the format of the number). Thanks

Upvotes: 1

Views: 499

Answers (1)

player0
player0

Reputation: 1

try:

=SUBSTITUTE(SUBSTITUTE(A1, ".", ), ",", ".")*1

where A1 is your IMPORTXML formula

enter image description here

and format it as number:

enter image description here

Upvotes: 2

Related Questions