Text to Numbers

[Simon Pipe]

Hi,

I have a worksheet with the following in one cell:

Aug 1 2011 1:00AM

It is formatted in TEXT and I am unable to change them to date format in the normal way.

Ideally I would like to convert it to dd/mm/yy (not bothered about the time)

Any ideas?

Thanks!

 

[Charlie45]

Selct Cell with the Date & Tme.
Selct Data > Text to Columns
Select Fixed Width. Click Next
Drag all the vertical lines to the end of the Date field click Next
Highlight the column with the date. Select Date
Highlight the column with the time. Select Do no import column. click finish

You will have your date in the cell

 

[Simon Pipe]

Charlie45 - Genius - Thanks!

 

[Charlie45]

You're welcome. glad I could help.

Thanks for the feeback.