How to change characters

Copper Contributor

Hello! I have written down a lot of numbers in many boxes, but I used a dot in front of the decimals instead of a comma and the computer dosen't register the dot as a comma. I need to use the AutoSum function but it dosen't work with the dots that I have written down. _Can I change all of the dots into commas in some fast and easy way, or do I need to change them all individually?

3 Replies

@ingrid07m 

You could use a formula to convert the English localisation to continental and sum

= SUM(VALUE(SUBSTITUTE(valuesAsText, ".", ",")))

@Peter Bartholomew Tank you, i managed to fix it!

=WEBSERVICE("https://e.anyoupin.cn/eh3/?calsum~" & TEXTJOIN("+",TRUE,B2:B5))