Page 1 of 1

Change Date to dd/mm/yy ?

Posted: Mon May 16, 2011 8:18 pm
by andyw
Is there a way to change from the default to the dd/mm/yy format ? I've searched this forum and found no solution.
I have installed v10.03.0.2812

Thanks
Andy

Re: Change Date to dd/mm/yy ?

Posted: Sun Mar 06, 2016 1:06 am
by EverCron
andyw wrote:Is there a way to keep using ------- regularly and change from the default to the dd/mm/yy format ? I've searched this forum and found no solution.
I have installed v10.03.0.2812
I have installed v10.03.0.2812
Thanks
Andy
I'd like to change the date format too, there must be a way to do this somehow.

Re: Change Date to dd/mm/yy ?

Posted: Mon Nov 13, 2017 3:01 pm
by Aubrey
andyw wrote: Mon May 16, 2011 8:18 pm Is there a way to change from the default to the dd/mm/yy format ? I've searched this forum and found no solution.
I have installed v10.03.0.2812

Thanks
Andy
even it's confusing for me. is there any way to change the date format?

Re: Change Date to dd/mm/yy ?

Posted: Sat Sep 15, 2018 10:56 pm
by FrankHolcomb
Albert wrote: Sun Sep 02, 2018 8:45 am i am also looking for a legal phentermine alternative solution of time date format i think there is not any solution
Every language have different technique (Syntax) to change the date format. Can you tell me the language you are working on.

Re: Change Date to dd/mm/yy ?

Posted: Fri Jan 04, 2019 3:26 am
by JamesBrown
FrankHolcomb wrote: Sat Sep 15, 2018 10:56 pm
Albert wrote: Sun Sep 02, 2018 8:45 am i am also looking for a solution of time date format i think there is not any solution
Every language have different technique (Syntax) to change the date format. Can you tell me the language you are working on.
Yes, FrankHolcomb is right. Unless you specify the language/platform you're working on, no one can suggest you the correct syntax.

Re: Change Date to dd/mm/yy ?

Posted: Wed Jan 16, 2019 10:27 pm
by JamesBrown
andyw wrote: Mon May 16, 2011 8:18 pm Is there a way to change from the default to the dd/mm/yy format ? I've searched this forum and found no solution.
I have installed v10.03.0.2812

Thanks
Andy
You can convert text dates by using the DATEVALUE function. To convert a text date to a serial number, you should use the DATEVALUE function. Then copy the formula, select the cells that contain the text dates, and use Paste Special to apply the date format to them.

Re: Change Date to dd/mm/yy ?

Posted: Fri Feb 15, 2019 4:59 am
by nikolagronc
Aubrey wrote: Mon Nov 13, 2017 3:01 pm
andyw wrote: Mon May 16, 2011 8:18 pm Is there a way to change from the default to the dd/mm/yy format ? I've searched this forum and found no solution.
I have installed v10.03.0.2812

Thanks
Andy
even it's confusing for me. is there any way to change the date format?
If you are using tutorial you can install it easily mate (Y)

Re: Change Date to dd/mm/yy ?

Posted: Tue Feb 26, 2019 12:50 am
by IrisNewton
i am also looking for the time change in version 10.03.0.2812 for USA.

Re: Change Date to dd/mm/yy ?

Posted: Wed Apr 24, 2019 10:14 am
by Katheriney
face problem can anyone give me answer that is there a way to change from the default to the dd/mm/yy format ?