•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
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