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.
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.