Forum Discussion
Not able to enter Dec 23 as a data in excel cell. It converts to Dec 24 as Enter button is pressed
Hi there,
I am not able to enter Dec 23 as a data in excel cell, but as i press ENTER button, it changes to Dec-24.
Kindly resolve this issue.
I want to enter Dec 23 in a cellBut as i press ENTER button it changes to Dec-24.
Please check in formula bar what it shows after you enter Dec 23. Most probably that's 23 December 2024 shown in your regional format. If so, that's only to apply custom format mmm dd to the cell.
Please check in formula bar what it shows after you enter Dec 23. Most probably that's 23 December 2024 shown in your regional format. If so, that's only to apply custom format mmm dd to the cell.
- So how i could enter Dec 2023 as Dec 23, can you please eloborate.
- SergeiBaklan, sorry i got it. Thanks. Ignore the previous reply.
Vineet2300 , you are welcome
