How to Keep the Australian Date Format in Excel for the Web
Question details
Users need to maintain the Australian date format (day/month/year) when working in Excel for the Web without it automatically converting to the US format.
- Product
- Excel for the Web
- Device & OS
- not provided
- Scenario
- Entering, viewing, and collaborating on spreadsheet data online.
- Observed behavior
- Australian dates automatically display in the US month/day format because the web version of Excel pulls regional settings from the Microsoft account profile rather than the local computer's Windows settings.
Ensure you are logged into your Microsoft account and verify that the dates in your spreadsheet are entered as actual date values rather than plain text strings.
Update Regional Settings in Excel for the Web
Change your region settings directly within the Excel web interface so your account correctly applies the Australian date format.
Because Excel for the Web relies on cloud-based account settings, updating your local computer's clock will not change how dates look online. You must apply the correct regional format directly through the web application's options menu.
Click on the 'File' tab located in the top-left corner of the Excel for the Web interface, then select 'Options'.
Click on 'Regional Format Settings' from the available menu options to open your account's locale preferences.
Click the dropdown menu, select 'English (Australia)' from the list of regions, and apply the changes. Your date values will instantly reformat to match the day/month/year layout.
Convert Text Dates to Actual Date Values
Regional settings only apply to recognized date values. You must ensure your cells are formatted as numbers or dates, not plain text.
Use WPS Office to Keep Your Local Date Formats Flawlessly
Tired of web applications overriding your computer's local date and time formats? WPS Office is a powerful, lightweight suite that natively respects your local Windows and macOS regional settings. Switch to WPS Spreadsheet to easily manage your data in the exact formats you prefer.
- 1. Install WPS Office: Download and install the free WPS Office suite from the official website onto your computer.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheet and seamlessly open your existing .xlsx workbooks.
- 3. Enjoy Native Formatting: View and edit your data immediately; WPS Spreadsheet completely bypasses online account overrides and uses your preferred local Australian date formats.
Frequently Asked Questions
Why does Excel for the Web ignore my computer's local date settings?
Unlike desktop applications, Excel for the Web operates in the cloud and pulls its formatting rules from the regional settings assigned to your Microsoft account profile. If your account defaults to the US, your dates will appear in the US format.
Will changing my region in Excel for the Web affect my collaborators?
No. Regional format settings in Excel for the Web are user-specific. If you set your region to Australia, you will see the dates in day/month/year format, but a collaborator in the US will see those exact same dates in month/day/year format according to their own account settings.
What happens if my dates were typed as text before I changed the region?
If you typed a date and Excel recorded it as text, changing the region will not update its appearance. You must select the cells, change the format to 'Short Date' in the Home tab, and potentially re-enter the data so the system recognizes it as a true date value.
