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


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!