- Joined
- Dec 21, 2015
- Messages
- 3
- Reaction score
- 0
Hello,
For some unknown reason, the "Short Date" format in my Excel installation changed some months ago.
When I type 8/11 into the cell of a new worksheet, i get "08 11 2015" displayed. This format corresponds to the "Short Date" format in Excel, as you can see below.
However I never wanted this, as I prefer "8-Nov-15" to avoid confusion with USA standards.
The asterisk tells that the format derives from the OS. This is not true as my OS says "ddd d-mmm-yyyy" as you can see below. So it DOES NOT derive from the OS.
Can someone explain this strange thing and how I can align them again, or at least set it back to "d-mmm-yyyy"?
Just to make sure: I need to change the "Short Date" format and not the format of just one particular cell...! So I find it back as I want it, tomorrow when I start Windows again
Thank you,
Stefano Gatto
Geneva, Switzerland
For some unknown reason, the "Short Date" format in my Excel installation changed some months ago.
When I type 8/11 into the cell of a new worksheet, i get "08 11 2015" displayed. This format corresponds to the "Short Date" format in Excel, as you can see below.
However I never wanted this, as I prefer "8-Nov-15" to avoid confusion with USA standards.
The asterisk tells that the format derives from the OS. This is not true as my OS says "ddd d-mmm-yyyy" as you can see below. So it DOES NOT derive from the OS.
Can someone explain this strange thing and how I can align them again, or at least set it back to "d-mmm-yyyy"?
Just to make sure: I need to change the "Short Date" format and not the format of just one particular cell...! So I find it back as I want it, tomorrow when I start Windows again
Thank you,
Stefano Gatto
Geneva, Switzerland
Last edited: