Learn Excel 2010 – “Lat 12 34.567”: Podcast #1475
A Facebook posting asks how to convert a column of 7 digit numbers (ie, 1234567) into the format of “Lat 12 34.567”. The answer is easier than you might think. In Episode #1476, Bill shows us a non-formula way to answer the question and get the result.
…This blog 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!
Entry filed under: Excel 2010, Learn Excel 2007 through Excel 2010, Learn Excel 2010, Learn Excel from MrExcel, MrExcel Podcast, MrExcel Products, New MrExcel Publication. Tags: accounting, Bill Jelen, business, Custom, Custom Number Formats, Customizing, Excel, Format Cells, Formatting, Formatting Cells to a Custom Look, MrExcel, Number Formats, spreadsheets, technology, tutorial, Worksheet.