Simons gets an accounting file from the company system. When he opens the accounting file, some G/L [General Ledger] codes are converted from the N-NN-NNNN Format to Dates, by Excel. Today, how to prevent this from happening is the subject Bill works with in Episode #1506.
...This episode is the video podcast companion to the book, "Learn Excel 2007 through Excel 2010 from MrExcel". Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book!
"The Learn Excel from MrExcel Podcast Series"
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!