need help reformatting a date from old dos file

		Microsoft Office Forums > Microsoft Excel > Excel
need help reformatting a date from old dos file

FAQ

Thread Tools

Display Modes

01-05-2017, 12:27 PM

SVanderkolff SVanderkolff is offline

Windows 10 need help reformatting a date from old dos file

Office 2013

Novice

Join Date: Jan 2017

Location: Mildmay, Ontario, Canada

Posts: 3

need help reformatting a date from old dos file

I have a CSV file that I have imported into excel that originated in an older DOS based program. The date comes across in a format of 101202 being December 2 2010. I need to get it into a format that Excel recognizes as a date.

Any help greatly appreciated.
Thanks
Steve

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Prevent XL from reformatting when data copy/pasted	BRDas	Excel	8	05-10-2016 01:24 PM
How can a document have the same date modified/create date, yes have have actual file content?	legaleagle	Word	15	01-07-2015 06:58 PM
Reformatting the spacing for numbers	Metro57	Word	1	04-07-2014 08:00 PM
Creating booklet without reformatting	Acesfull145	Word	0	08-21-2013 07:42 AM
Heading styles constantly reformatting	lizziecassmaran	Word	8	12-11-2011 01:32 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:50 PM.