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...
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!
