Excel for the web
Welcome to the web version of Excel's feedback forum! This is the place for users to send us suggestions and ideas on how to improve. To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.
-
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.
580 votesHey 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?