Allow me to change regional settings: date formatting (mm/dd/yy, dd/mm/yy), thousands/decimal separators (period vs comma), formula language
Excel Online decides how to show dates and numbers and formulas based on where I live. I want to be able to choose how to display these Excel items. For dates, I might want mm/dd/yyyy, or I might want dd/mm/yyyy. My Excel formulas should be in the language of the application, and not based on where I live.579 votes
Hey all, we’re happy to share that we’ve added an option to define regional format from within Excel for the Web.
Go to File menu —> Options —> Regional Format Settings and choose your preferred regional format.
Alternative way is selecting a cell, go to Number Format dialog (via ribbon or right-click), select Date/Time/Special category, and choose the preferred regional format. To make this your default regional format, tick the checkbox.
This new capability is supported in SharePoint Online, OneDrive, Exchange and also through Teams and Office.com.
Thank you for voting and influencing our priorities. Keep voting for other ideas you want us to address.
Thanks, Excel team.
- Don't see your idea?