Wrong date format on google spreadsheet

Anytime that I save time format in US form (mdy) it says "oops, something went wrong". What needs to be done? Also dates saved in my google spreadsheet are in Asia format (dmy). Please advise.

Hi,

Submissions dates passed on Google Spreadsheet are based on your account timezone. So if it's set on Asia time (format) currently, that will be used during the submissions. When you made changes on your timezone, it should reflect on the new submissions.

The error you have reported usually occurs when you save the same time format that is already set on your account. I check your account and it's already on the desired time format so I assumed this was already resolved?

I have also tested it on my account and it is working fine. If you're already on US time format, there's no need to set it again.

Hope this information helps. If you have further questions, let us know.

Regards!