Microsoft Office Forums - View Single Post - need help reformatting a date from old dos file

Thread: need help reformatting a date from old dos file

View Single Post

Old

01-05-2017, 12:27 PM

SVanderkolff SVanderkolff is offline

SVanderkolff is offline

SVanderkolff uses Windows 10

Windows 10 SVanderkolff uses Office 2013

SVanderkolff uses Office 2013

Office 2013

Novice

The original poster

Join Date: Jan 2017

Location: Mildmay, Ontario, Canada

Posts: 3

SVanderkolff is on a distinguished road

Default

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

Reply With Quote