Previous Topic Next Topic

Date format

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

1 response

Réponse 1 / 1
sgmpatnaik Posts 52 Registration date Tuesday 2 April 2013 Status Member Last seen 27 November 2013 45
6 Jul 2013 à 09:52
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