Convert text to date format

		Microsoft Office Forums > Microsoft Excel > Excel
Convert text to date format

11-14-2015, 03:52 PM

shg

Windows 7 64bit Convert text to date format

Office 2010 32bit

Advanced Beginner

Join Date: Oct 2015

Posts: 55

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.

Tags

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:46 AM.