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
5 Replies
You should enter the date according to your system date format, and format the cell according to the way you want it displayed.
So if your system uses dd/mm/yyyy, you should enter 10/2/21 and format the cell as yyyy/mm/dd.
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.
