Date format

Closed
Posts
1
Registration date
Saturday July 6, 2013
Status
Member
Last seen
July 6, 2013
-
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
-
in MS-Excel, When i am sorting the dates in a column of format dd/mm/yyyy, say example 10/06/2007 and 02/10/2007, the sorted column shows 02/10/2007 in first row.
Please suggest me, how can i solve this problem. tell me step by step

1 reply

Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
44
Hi

I think your Date Format in your system as MM/DD/YYYY so you want the format as DD/MM/YYYY then please follow the instruction below

1. Select the Entire Column

2. Right click your mouse button

3. Select the Format Cells

4. In General Tab Select the Date and in Type option select the Date format to *14/03/2001

5. again select the Custom option in General Tab

6. There you select the Date format as dd-mm-yyyy

Hope it is solve your problem other wise please inform us

Thanks

SP