Forum Discussion
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 updated to Office 365.
After reading various posts I have changed the language setup in office locally and in OneDrive online, however the region could be changed but the standard language can't be amended.
Pleased to hear how to change the setup back to the English version.
Regards,
Mischa Kooij
3 Replies
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
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)
- 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.
