Forum Discussion
rhytmify
Mar 23, 2024Copper Contributor
Excel formula delimeter
In formulas I have ";" delimiter - IF(logical_test;value_if_true;value_if_false). But I need it to be "," - IF(logical_test,value_if_true,value_if_false). Can I do it on macbook sonoma 14.1? I co...
HansVogelaar
MVP
Apple menu > System Preferences > Language and Region.
If you want to change the setting for all apps, click Advanced and specify the number and currency separators.
If you want to change it for Excel only, first click Apps. Then click the big + button and add Excel.
rhytmify
Mar 24, 2024Copper Contributor
Thanks for your reply, but there is no Advanced in Language & Region, all settings are listed directly under Language & Region
- HansVogelaarMar 24, 2024MVP
I don't have a Mac myself, so I hope that someone who does can help you.