Change date Locale

Closed
Report
Posts
1
Registration date
Thursday March 20, 2014
Status
Member
Last seen
March 20, 2014
-
 praveer -
I Want to change date format dd-mm-yyyy to dd/mm/yyyy in MS Excel 2003
Please solve my problem urgently

3 replies

Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
praveer V Kotian, good morning.

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

Is it what you want?
I hope it helps.
its not working, in custom dd/mm/yyyy format not found.
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
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.
thank you, Its working..... my problem solved