LinkBack URL
About LinkBacks
I have a cell formatted for short date.
When I type "2/29" and hit enter it returns "2/1/2029"
Help.
Thanks,
clarbare2
I have a cell formatted for short date.
When I type "2/29" and hit enter it returns "2/1/2029"
Help.
Thanks,
clarbare2
Right click on the cell and choose Format Cells. Click on Date, Custom and enter mm/dd for 02/02, or mmm/dd for Feb/02, or mmm - dd for Feb - 02 or something along those lines to get the month and date that you want.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
What do you mean by 'short date'. i.e. what do you expect to see?
Is that date meant to be 29th February? And since 2014 (the default year if you enter 2/29) is not a leap year, Excel will not know what you mean.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks guys. It was the Feb 29th thing that was throwing it off. I'm feeling pretty stupid right now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks