Convert text to date format

klllmmm · #1 11-14-2015, 10:57 AM

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?

shg · #2 11-14-2015, 03:52 PM

Quote:

Originally Posted by klllmmm

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)

No.

1. Select the column

2. Select the Data tab

3. Press the Text to columns button.

4. Press Finish.

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