Forum Discussion

GIllesvh's avatar
GIllesvh
Copper Contributor
Oct 17, 2022

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 options and change this separation into a comma it should change in your table. 

when i make this change it doesn't change the points into comma's. 

anyone that has solved this problem?

 

kind regards

Gilles Van Hout 

Formulas and Functions
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Oct 17, 2022

    GIllesvh 

    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.

     

    NikolinoDE

    I know I don't know anything (Socrates)

Resources