Home / MS-Excel / Excel 2003

Excel Numerical Entry Express

Numbers, numbers, numbers. Spreadsheets are full of them, and because they don't get there by magic, it behooves you to know all the tricks of the trade for entering them as efficiently as possible. The first trick is the most obvious - use your computer's 10-key pad (or the equivalent thereof) to make all your numerical entries. The second trick is to let Excel set the decimal places in your numerical entries that all use a set number of places (that way, you can concentrate on just entering the correct digits). The third trick is not to allow any errant text entries into a cell range that should only contain numbers.