Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Converting Text Dates To Excel Dates En Masse

K2 Enterprises
5.08K subscribers
<__slot-el>
<__slot-el>
62K views 12 years ago
Frequently, when exporting data out of an enterprise application into Excel, dates export as text entries. When this occurs, it might be necessary to convert the text dates to Excel dates so that you can perform calculations in Excel. In this tip, you will learn how to quickly convert "text dates" to "Excel dates" using a long-standing feature in Excel. ...more
...more
Converting Text Dates To Excel Dates En Masse
139Likes
62,142Views
2012Nov 27
Frequently, when exporting data out of an enterprise application into Excel, dates export as text entries. When this occurs, it might be necessary to convert the text dates to Excel dates so that you can perform calculations in Excel. In this tip, you will learn how to quickly convert "text dates" to "Excel dates" using a long-standing feature in Excel.

Follow along using the transcript.

K2 Enterprises

5.08K subscribers