How to convert existing date to another date format in Excel [Closed]

Report
Posts
4
Registration date
Wednesday November 5, 2014
Status
Member
Last seen
December 30, 2014
-
Hello,

I want to convert existing date like- 18.5.2014 to another date format like- 18 May, 2014 in office Excel 2007.

Existing format is-

18.05.2014
19.05.2014
21.05.2014
25.05.2014
18.05.2014
28.05.2014

But I want to convert these the following scenario in a easy way because there are various dates in a column.

18 May, 2014
19 May, 2014
21 May, 2014
25 May, 2014
18 May, 2014
28 May, 2014

Please help me to solve this problem.

Thanks and regards.

Biswajit

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!