Forum Discussion
Date format
The problem of switching the day and year when writing the date i wanted yyyy/mm/dd 10 February 2021 ( 21/2/10) it appears 21/02/2010
thank you for quickly reply
system date now 05/05/2023
how can I set date format
from custom format or date
Select the cell or cells in which you want to enter dates.
Press Ctrl+1 to activate the Format Cell dialog.
Activate the Number tab (if it isn't already active).
Select Custom in the Category list.
Enter yyyy/mm/dd in the Type box, then click OK.
You'll still have to enter the date as 5/5/23 or 05/05/2023 or 5-May-23.
The value will be displayed as 05/05/2023 in the formula bar, and as 2023/05/05 in the cell itself.
- Thank you very much
It solved for the current day date but still wrong for the date 14/02/2021 it appears 14/2/21That makes me think your system date format is m/d/yyyy or a variation thereof.
If that is correct, you have to enter the 14th of February 2021 as 2/14/21