Change date Locale

Closed
praveer V Kotian Posts 1 Registration date Thursday March 20, 2014 Status Member Last seen March 20, 2014 - Mar 20, 2014 at 08:16 AM
 praveer - Mar 22, 2014 at 12:10 AM
I Want to change date format dd-mm-yyyy to dd/mm/yyyy in MS Excel 2003
Please solve my problem urgently

3 replies

Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Mar 20, 2014 at 09:28 AM
praveer V Kotian, good morning.

Select cell
--> Menu Format
--> Cells
--> Number
--> Custom
-----> dd/mm/yyyy

Is it what you want?
I hope it helps.
0
its not working, in custom dd/mm/yyyy format not found.
0
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Mar 21, 2014 at 06:46 AM
praveer, Good morning.

You do not need to find a ready formatting you want.

You can create a new format according to your need.
In the field below the word TYPE, enter dd / mm / yyyy.

Try creating various other ways.
dd---mm---yyyy
dd~~~mm~yyyy
dd.mm.yy

Is it what you want?
I hope it helps.
0
thank you, Its working..... my problem solved
0