Excel: Type 123 to Enter 1.23

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Excel can automatically insert s decimal point like the old adding machines. Go to File, Options, Advanced.

  1. When you type 123, Excel will enter 1.23