u/hkatlady

▲ 1 r/excel

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?

reddit.com
u/hkatlady — 3 hours ago