Episode # 732 - Dates from Text to Columns

Prevent Text to Columns from converting 7-3 to a date

Sponsored by

Check out this book for more tips
similar to this lesson!

Tuesday, April 08, 2008

Jonathan notices a problem when he uses the Text to Columns wizard. Baseball scores such as 4-3 are converted to dates. In episode 732, we'll take a look at how to keep those scores from being converted. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

You don't need to go spend an entire day at the local computer chain store to learn Excel. Take 2 minutes to learn this lesson now with our free video!

Watch Video

Click Play icon to play the video. You might first need to click on the Video to activate Flash player.

Tags/Keywords for this video: dates, text to columns

Episode # 732 - Dates from Text to Columns

Prevent Text to Columns from converting 7-3 to a date

More Excel Video Lessons