Question: how to change date format in excel to australian?
Answer: Use the Locale drop-down list to choose the area you want. (The Locale drop-down list is visible only after you complete step 4.) In John's case, he should choose English (Australia). Excel then changes what date formats are available in the Type list, just above the Locale drop-down.