Have a Question?

If you have any question you can ask below or enter what you are looking for!



Hi,

I want to change the below date in date format e.g (03/10/2011) and Then change the format of the date in (10-Mar-011)


Date
10.03.2011
11.03.2011
10.03.2012
11.03.2012
10.03.2013
11.03.2013

  Sachin Yadav

Hi Sachin, 

You can change this date format using text to column option in Data tab or ALT+A+E, then select delimiter->Next->select Date Option then select DMY format from drop down then next. Now text will be formatted as date, then goto format cell and custom option and change formate as dd-mmm-yy.



  Devendra Singh       05 Jul 2016       1       0     

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any