•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?
Our take
If you have a list of dates formatted as mmm-yy (like apr-26 or aug-33) but are facing issues with Excel interpreting them incorrectly, you're not alone. Excel often misreads the last two digits as a day instead of a year, leading to confusion when trying to sort your data. Fortunately, there are effective methods to convert these values into the correct mmm-yy format. This guide will walk you through the steps to ensure your dates are accurately represented and easily sortable in Excel.
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]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#rows.com#natural language processing for spreadsheets#generative AI for data analysis#large dataset processing#dates#mmm-yy#excel#format#month#year#day#transfer#sorting#list#values#correct#proper