February 13, 2012 archive

Converting Text Dates to Proper Dates in Excel the Easy Way

From time to time you might receive an Excel spreadsheet that has been created by an application but it has output the dates in its own text format instead of being stored as an actual date value. I’ve seen instances where the time has been placed before the date which would leave many to think …

Continue reading