Excel date in English
Christine Monette
-
RF -
RF -
Hello, I have a problem with Excel and the date format. I want to write the date in English format with Excel, but the program automatically changes it to French.
For example: I write 15 Jan 04, it automatically changes to 15 Janv 04. I would like it to remain in English format; is that possible and how?
Thank you
For example: I write 15 Jan 04, it automatically changes to 15 Janv 04. I would like it to remain in English format; is that possible and how?
Thank you
3 réponses
The "Date" category in the "Number" tab of the cell format only allows for a limited number of predefined formats. For more flexibility, you need to choose the "Custom" category.
To obtain an English format, you must precede the format with [$-809].
Example: the format [$-809]dd-mmm will yield 15-Dec (without the accent on December, as we are indeed in English).
To find the country codes to place in the brackets, you just need to go through a standard date format by selecting the desired regional settings (see dje-dje's response), and then modify it to custom.
To obtain an English format, you must precede the format with [$-809].
Example: the format [$-809]dd-mmm will yield 15-Dec (without the accent on December, as we are indeed in English).
To find the country codes to place in the brackets, you just need to go through a standard date format by selecting the desired regional settings (see dje-dje's response), and then modify it to custom.
I would have never found this format on my own.