• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Entering Numeric Data

There's really no trick to entering numeric data—simply click in the cell that will contain the number, and type it, using either the number keys above the alpha-keyboard, or the numeric keypad (be sure NumLock is on). You'll notice that as soon as you press Enter or Tab (or the arrow keys) to move to another cell, the numeric content is automatically right-aligned. This is because columns of numbers are best viewed with their decimals (or lack thereof) lined up on the right, as shown in Figure 2.16.

Excel makes some formatting decisions of its own that you can either accept or reformat later, when all of the entries are made, or before you make any entries at all. It's a good idea to familiarize yourself with the following list of numeric tricks as performed by Excel:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint