Cannot enter dates in English (Australia) format

letslightafire 

It seems like your Excel is defaulting to the USA date format even though your language and region settings are configured for Australia. Here are a few steps you can try to resolve this issue:

1. Check Excel's Language Preferences: Ensure that Excel's language preferences are also set to English (Australia). You can usually find this setting under Excel Preferences > General > Language.
2. Change System Date Format: Sometimes, Excel takes the date format from the system settings. Make sure your Mac's system date format is also set to English (Australia). You can adjust this in your Mac's System Preferences > Language & Region > Advanced > Dates.
3. Check Date Format Cells: Ensure that the cells where you are entering dates are formatted correctly. You can do this by selecting the cells, right-clicking, choosing Format Cells, and then selecting the appropriate date format under the Number tab.
4. Use Text-to-Columns Feature: As a workaround, you can use the Text-to-Columns feature to parse dates. Select the column with dates, go to Data > Text to Columns, choose Delimited, and then select the appropriate date format. This may help Excel recognize the dates correctly.
5. Repair Office Installation: If none of the above steps work, try repairing your Office installation. Sometimes, corrupted installation files can cause unexpected behavior.

The text and steps were edited with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.