Forum Discussion

MischaKooij's avatar
MischaKooij
Copper Contributor
Jan 14, 2020

Function type and language setting

Good day,   When I use e.q. the IF function i need to use ; (Dutch version) for separation instead of , (English version). I was previously working in Office 2010 English setup and recently we upda...
excel
Formulas and Functions
PascalKTeam's avatar
PascalKTeam
Iron Contributor
Jan 14, 2020

Hi MischaKooij If you want to change the separator for functions, go to control panel, region, additional settings and then change the list separator. 

 

Hope this solves your issue

  • MischaKooij's avatar
    MischaKooij
    Copper Contributor
    Jan 14, 2020

    PascalKTeam many thanks for your reply.

     

    The separator is already at ,

     

    Still have the problem that Excel doesn't reckon ; as a ,

    should be =if(A1=0,1,2) but still have to use ; thus =if(A1=0;1;2)

     

    • PascalKTeam's avatar
      PascalKTeam
      Iron Contributor
      Jan 14, 2020
      Hmmm I don't know of any other setting than this. Maybe you need to restart Excel after you change the setting or even reboot your PC.

Resources