Convert text to date format

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

FAQ

Thread Tools

Display Modes

11-14-2015, 10:33 AM

klllmmm

Windows 10 Convert text to date format

Office 2016

Novice

Join Date: Nov 2015

Posts: 4

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..

Tags

date format, formulas, text conversion

« Previous Thread | Next Thread »

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 02:09 AM.