Join Dennis Taylor for an in-depth discussion in this video Converting unusually formatted dates into usable data (text to columns), part of Working with Dates and Times in Excel 2007.
When you download information from other sources, sometimes you end up with…date formats, or date entries, that are not in a good Excel format that you can do much with.…Now, some of these are a little unusual, but yet there are techniques in Excel…to handle and change date information.…Think of situations where you might have thousands and thousands of entries.…In columns A, D, and G, we see three different kinds of date layouts here.…All of them are a little bit unusual perhaps, but they all make sense in a certain way.…
If we look at the data in column A, after looking at this for a bit, I think you…recognize that the year is embedded in here, but the first two characters are…the day of the month, then a four-digit year, then the actual month number.…So let's convert this data into something we can work with effectively in Excel.…The best way to do this is to select the entire column, when appropriate, or the…data in question, and go to the Data tab, and choose Text to Columns.…This sounds as if we might be splitting it into separate columns, but…
- Understanding how Excel records and stores dates and times
- Looking at standard date/time entry options and acceptable alternatives
- Using the TODAY and NOW functions
- Customizing date formats
- Exploring keyboard shortcuts
- Formatting time for hours over 24
- Calculating differences across dates and times
- Rounding calculations
- Working with holidays
- Validating with dates
- Converting formatted dates to usable data
Skill Level Intermediate
Creating Business Budgets in Excel 2007with Curt Frye1h 3m Intermediate
Excel 2007: Introduction to Formulas and Functionswith Curt Frye2h 26m Intermediate
1. Excel's Date/Time System
2. Creating Date/Time Entries
3. Date/Time Formatting
4. Excel's Date/Time Functions
5. Calculating with Dates and Times
6. Using Dates and Times with Excel Commands
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.