Forum Discussion
Solved
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.
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.