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...
rhytmify
Mar 24, 2024Copper Contributor
thanks, but whatever I choose in Number format, formulas are still with semicolon, it impacts only numbers for me. I also uncheck and checked Use system preferences in Microsoft Excel/Preferences/Edit/, but result was the same
- HansVogelaarMar 24, 2024MVP
If you clear the check box 'Use system preferences', what is the decimal separator listed below it?