Cannot enter dates in English (Australia) format

letslightafire 

Apologies for the confusion. You're correct that the language preferences in Excel are more prominent in the Windows version. In the Mac version, Excel typically takes its language and regional settings from the system preferences.

Since you've already checked and adjusted your Mac's system date format and formatted the cells correctly, and you're considering using the Text-to-Columns feature as a workaround, let's explore another potential solution:

You can try creating a custom date format that mimics the Australian date format explicitly. Here's how you can do it:

1. Select the cells containing dates.
2. Right-click and choose "Format Cells..."
3. In the Format Cells dialog box, go to the "Number" tab.
4. Select "Custom" from the list on the left.
5. In the "Type" field, enter the custom date format: dd/mm/yyyy
6. Click OK to apply the custom format.

This custom format explicitly tells Excel to display dates in the format Day/Month/Year, which should match the Australian date format.