Excel date in English
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 answers
-
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.-
-
-
-
@100daysnomadWhat simplicity in Excel really... what an intuitive tool....!!!!
[$-809].... well yes, it's obvious, isn't it!.........why didn't I think of it earlier..... -
-