convert cell that looks like date to an actual date

**maacmaac** · 03-30-2013, 10:20 AM

I have a number of cells that are formatted as text and are as follow:

1-SEP-2014
15-MAR-2009
1-JUL-2018
12-SEP-2022
3-JAN-2009
22-JUL-2018

I've been trying to format cells as date but no luck. Is there a quick formula I could use to convert these cells to mm/dd/yyyy format? Thanks

**benishiryo** · 03-30-2013, 10:29 AM

hi maacmaac. select the data & go to Data-> Text to Columns -> Delimited -> Next -> Next -> Date: DMY
then format to what you need

to do a formula on another column, simply:
=A1+0
format the cells

**martindwilson** · 03-30-2013, 10:31 AM

select range then
data
text to columns
click next twice
from column data format choose date and set to dmy
click finish

**Tony Valko** · 03-30-2013, 10:31 AM

This worked for me...

Select the range of cells in question
Goto Data>Text to Columns
Click Next twice
In Step 3 of the userform, under Column data format, select Date.
From the drop down list select DMY
Click Finish

Then, format the dates in the date format of your choice.

**Fotis1991** · 03-30-2013, 10:31 AM

Maybe text to columns option?

**Fotis1991** · 03-30-2013, 10:34 AM

3 answers in same minute? Bingo!!

But Ben you are much faster..!!!!!

**Tony Valko** · 03-30-2013, 10:40 AM

I'm the worlds slowest typist!

A post like this:

http://www.excelforum.com/showthread...=1#post3172410

Takes me about an hour to type!

**Fotis1991** · 03-30-2013, 11:16 AM

@ Tony Valko

CAN You think to yourself, how much harder it would be if you had to "translatE" of your thoughts?

@ maacmaac

You are welcome.No. There is no need to thank us..It's just our obligation ...