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

Report

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

How to convert existing date to another date format in Excel
How to convert date from dot to slash format in excel ✓ - Forum - Office Software
How to convert date to dd/mm/yyyy format in excel - How-To - Excel
Change date format dd.mm.yyyy to dd/mm/yyyy ✓ - Forum - Excel
How to convert a numeric value into english words in excel 2007 ✓ - Forum - Word
Convert number into words in excel 2007 ✓ - Forum - Word

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

Your reply

Subscribe To Our Newsletter!