Forum Discussion
changing separator from points to comma
hello everyone! i am making some basic calculations and I get the value error when doing this because of the points between numbers. I want to change these into comma's. I know if you go to opt...
with formula:
Englisch: =SUBSTITUTE(A1,".",",",)*1
Before doing the conversion through the formula, you should check if the cells are formatted correctly. To be able to replace with the formula, the cell must be formatted as DEFAULT.
or make systemic changes...proceed as follows:
Navigate to the menu item "File > Options." In the next step, switch to the "Advanced" selection menu. In the lower part of the "Advanced" selection menu you will find the entry "Accept separator from operating system".
After deactivating the checkbox, you can replace both the decimal separator and the thousands separator with a period.
Hope I was able to help you with this info.
I know I don't know anything (Socrates)