Previous Topic Next Topic

How to convert existing date to another date format in Excel

Closed
Biswajit-Shaha Posts 4 Registration date Wednesday November 5, 2014 Status Member Last seen December 30, 2014 - Nov 5, 2014 at 10:26 PM
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
Related: