Forum Discussion
How to change characters
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?
You could use a formula to convert the English localisation to continental and sum
= SUM(VALUE(SUBSTITUTE(valuesAsText, ".", ",")))PeterBartholomew1 Tank you, i managed to fix it!
=WEBSERVICE("https://e.anyoupin.cn/eh3/?calsum~" & TEXTJOIN("+",TRUE,B2:B5))
