| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula bar shows mm/dd/yyyy. To show dd/mm/yyyy. How?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula bar shows mm/dd/yyyy. To show dd/mm/yyyy. How?
Control Panel Regional and Language Options select English (Australia)
OK out. "magna" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula bar shows mm/dd/yyyy. To show dd/mm/yyyy. How?
Thanks. That worked!
"Teethless mama" wrote: Control Panel Regional and Language Options select English (Australia) OK out. "magna" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change date format from dd/mm/yyyy to mm/yyyy | Excel Discussion (Misc queries) | |||
| want formula bar date to be dd/mm/yyyy instead of mm/dd/yyyy.How? | Excel Discussion (Misc queries) | |||
| How do I convert a birthdate format from yyyy/mm/dd to mm/dd/yyyy | Excel Worksheet Functions | |||
| how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel | New Users to Excel | |||
| change birthday display from mm/dd/yyyy to HIDE the yyyy? | Excel Worksheet Functions | |||
Linear Mode
