•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
date format has changed from slashes to commas
Our take
It sounds like you've encountered a frustrating change in your date formatting, where slashes have been replaced by commas in your spreadsheet. This shift can disrupt your workflow, especially since you were accustomed to entering dates like "4-24" to receive the expected "4/24/26" format. Fortunately, you can explore custom date formats to regain control over your display preferences. If you're seeking a solution to revert the system settings, consider checking your locale settings or formatting options to reset your date preferences. Let's tackle this together!
i did it again! so now short dates show with a comma between the numbers, instead of a slash like it used to. i can get around this by making a custom date format, but when i display the system provided date formats, it uses a comma instead of a slash. what the heck did i do this time?
and, i used to be able to enter a date like this 4-24, and it would make it 4/24/26.
i would like that to come back also. is there something i can reset?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#rows.com#Excel compatibility#Excel alternatives for data analysis#real-time data collaboration#financial modeling with spreadsheets#real-time collaboration#Excel alternatives#date format#slashes#commas#custom date format#system provided date formats#short dates#reset#enter a date#display#4-24#4/24/26#submitted by#comments