•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to turn all dates into mmm-yy format rather than month and day?
I have a large list of dates in the mmm-yy format ( for example apr-26, aug-33, etc.). When transferring to a date format, excel assumes that the last two digits are a day rather than a year (apr-26 becomes April 26th rather than April 2026). is it possible to transfer all of these values into the proper mmm-yy format so that they may be sorted by date?
[link] [comments]
Want to read more?
Check out the full article on the original site