1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

date format has changed from slashes to commas

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?

https://preview.redd.it/fk1jjuu0cfug1.png?width=217&format=png&auto=webp&s=cd614992772c2046fc800b0b4ebc5ea1526cdc0a

https://preview.redd.it/oef3v104efug1.png?width=269&format=png&auto=webp&s=95a7e2114983be0d98a64c31004b4cdd97e66e9c

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?

submitted by /u/hkatlady
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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