#1
|
|||
|
|||
Convert text to date format
I have a column consisting date details. But its just entered as texts.
How do I make it to a date format. Eg. July 17, 2015 August 4, 2015 August 4, 2015 August 23, 2015 July 21, 2015 July 13, 2015 July 9, 2015 June 23, 2015 June 27, 2015 June 26, 2015 October 9, 2015 October 18, 2015 Thank you very much for your valuable time.. |
#2
|
|||
|
|||
Select the column, Data > Text to columns > Finish
Then format however you like. |
#3
|
|||
|
|||
You mean divide this data in one cell to 3 separate cells, then can I combine to get date format? ( may use "& function" or concatenate)
How to identify month to this? |
#4
|
|||
|
|||
Found it from anther forum
=TEXT(MID(A1,FIND(" ",A1)+1,FIND(",",A1)-FIND(" ",A1)-1)&" "&LEFT(A1,FIND(" ",A1)-1)&" "&RIGHT(A1,4),"dd/mm/yy") |
#5
|
|||
|
|||
Quote:
1. Select the column 2. Select the Data tab 3. Press the Text to columns button. 4. Press Finish. |
#6
|
|||
|
|||
Another quick and easy way is to do this a find and replace, commas for commas. This is the way I used to do it in the good old days before Text to Columns came along.
|
Tags |
date format, formulas, text conversion |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Non-printing button to convert a date field to text | Greengecko | Word VBA | 1 | 09-09-2014 09:40 PM |
How to convert a text file to an Excel file with the data format automatically? | mradmin | Excel | 6 | 10-16-2013 10:34 AM |
Text auto formatted as date format | Aikeedoh | Excel | 5 | 09-06-2013 02:38 AM |
Cannot Convert Text Cell to number format to be able to sort the data | jyfuller | Excel | 10 | 06-19-2013 05:31 PM |
How can I convert pptx to text format like Word, and later on create pptx too? | GetLost | PowerPoint | 0 | 01-11-2012 04:23 AM |