International date format

[Allofus]

Hi all,

First of all I want to thank JoeMo and Rick Rothstein for assisting me in Warp Speed 6 time with something I know would be pretty basic at their level of exceptional expertise.

The issue I have now is I need to insert a date and time picker to my spreadsheet. I know how to do it, but my problem is, is it possible to change the date format?

I'll explain.
I am in Australia. I'm creating a spreadsheet for my work colleagues, some of which are LA based.
In Australia, our date format is dd/mm/yyyy.
This is how it appears when I insert the MS date and time picker.
I need it to show the US format, mm/dd/yyyy.

I've look in properties but there seems to be no way of doing this.

Any help would be appreciated.

 

[pedro-egoli]

Just go to Format /Custom and enter
mm/dd/yyyy

 

[Allofus]

Thank you Pedro,
I can do this with a cell, but I can't with MS Date and Time Picker
If you can bring up the properties for a Date and Time Picker, modify the settings and take a screen grab, that would be cool...

 

[pedro-egoli]

Sorry no can help have never used it.
Over to the experts

 

[Allofus]

Appreciate your input.
Good to hear from a fellow Gold Coaster!
I've decided to use the time and date picker and set extended format, Sunday 3rd March, 2019

 

[pedro-egoli]

What a coincidence.
I am 4216 P/C
Format looks the way to go

 

[Allofus]

4221 here