I need to change formula separator from comma to semicolon (matter of habit, used it for years). So that instead of
=SUM(25,98) I would use =SUM(25;98).
Excel 2016 has no "Options" window where you can do this change. System preferences in Macbook (Language & Region>Advanced) allow changing decimal and grouping separators only. Any advice?
Welcome to the board.
If you change the decimal separator to comma, the argument separator will change to a semicolon automatically -- on Windows, anyway.
Last edited by shg; 11-23-2015 at 03:47 PM.
Entia non sunt multiplicanda sine necessitate
...but isn't the grouping separator just another term for 'argument' or 'list' separator. Have you tried changing the grouping separator?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks for suggestions, but not on Macbook.
The grouping separator in this sense is separator for thousands. So changing did not help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks