Formula bar shows mm/dd/yyyy. To show dd/mm/yyyy. How?

M

magna

I am using Excel 2000 now. Opened a file created in Excel 97 now and find
that a cell in the Date column in the file now shows mm/dd/yyyy in formula
bar and in the cell display. In Excel 97, both displays were in dd/mm/yyyy
format.
I have tried to format the cell by changing the Date 'locale' drop down to
be "English(Australia)" instead of "English(US)". While this changes the cell
display to dd/mm/yyyy, the formula display is still mm/dd/yyyy.
How do I make both of these displays to be dd/mm/yyyy format that we use here?
 
T

Teethless mama

Control Panel > Regional and Language Options > select English (Australia) >
OK out.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
How to add day to PWA 2016 date format? 0
reformat dates to yyyy/mm/dd 5
Forcing a date entry format of dd/mm/yyyy 1
want formula bar date to be dd/mm/yyyy instead of mm/dd/yyyy.How? 1
How to enter a date in DD-MM-YYYY format 2
How to convert MM/DD/YYYY to Month 3
Returning the month (mmm) from cell in date format dd/mm/yyyy 3

Top