Previous Topic Next Topic

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