Keyboard Shortcuts to Format Spreadsheet Cells
If you frequently have to format cells after you've typed the information, you may want to take note of some of these keyboard shortcuts that allow you to format cells as you go. This information is for Excel 2007, Excel 2010, and Excel 2013.
If you enter a zip code like 08976, Excel will assume it is a number and will drop the leading zero to display 8976 in the active cell. If you enter an ' (apostrophe) before the value, Excel will accept the zip code as text.
To format a number as currency, type a $ (dollar sign) immediately before the value. For instance, type $200.00 for 200 dollars in currency format.
In Excel 2007 and Excel 2010, if you type 1/2 (1 slash 2) in an Excel cell, the resulting value will be the date 02-Jan. To enter a value in fraction format, precede your fraction by the number 0 (zero) > Press the spacebar > Type the fraction. In Excel 2013, you can just type 1/2 to get the desired result.
Enter the percent as a whole number (i.e., 75) followed immediately by a % (percent sign).Email this to a Friend