MrExcel’s Learn Excel #997 – 150 to 1.5

Shanna sends in today’s question. When she types three digits in a cell such as 150, the cell automatically changes to 1.5. Episode 997 takes a look at this bizarre problem and when this setting might actually be useful.

This video is the 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!