Convert text to date format

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

FAQ

Thread Tools

Display Modes

11-16-2015, 07:02 AM

gebobs

Windows 7 64bit Convert text to date format

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

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

« 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 06:34 AM.