Date format

Closed
new version Posts 1 Registration date Saturday July 6, 2013 Status Member Last seen July 6, 2013 - Jul 6, 2013 at 03:51 AM
sgmpatnaik Posts 54 Registration date Tuesday April 2, 2013 Status Member Last seen November 27, 2013 - Jul 6, 2013 at 09:52 AM
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

sgmpatnaik Posts 54 Registration date Tuesday April 2, 2013 Status Member Last seen November 27, 2013 45
Jul 6, 2013 at 09:52 AM
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
0