Date Formats in Worksheet

Ipshita

Just for knowledge -

Someone had raised this question about date formats in the community and I wanted to add the response to it so it might help some others as well. A mini disclaimer here that most of you might already know this but sometimes we all forget the most obvious things that are in front of our eyes so just take this in jest and don't hate me for pointing out the obvious! :)

So, in case any of you are looking to change the date format in your working sheet to anything different from your computer/regional settings, the easiest way is to go to settings in the left hand panel and hit the regional preferences option. Here you can modify the date format and your sheet/forms etc. will reflect accordingly.

Hope this helps :)

干杯!

Ipshita

Garrett.Ricker

is there a way to change the format to to show 1/1/23 as January 1, 2023 or any other variation of date format?