Basic formatting in Excel can customize the look and feel of your Excel spreadsheet. Learn about formatting cells in Excel here.

One of Excel's most useful features is its ability to format numbers and dates in a variety of ways. For example, you might need to format numbers with decimal places, currency symbols ($), or percent symbols (%).

- Select the cells you want to modify.
- Click the
**drop-down arrow**next to the**Number Format**command on the Home tab.Accessing Number Format commands - Select the number format you want. For some number formats, you can then use the
**Increase Decimal**and**Decrease Decimal**commands (below the Number Format command) to change the number of decimal places that are displayed.

Click the buttons in the interactive below to learn about the different number formats.

You can easily **customize any format** in **More Number Formats**.

For example, you can change the U.S. dollar sign to another currency sign, have numbers display commas, and change the number of displayed decimal places.

**Text** formats numbers as text, meaning what you enter into the cell will appear exactly as you wrote it. Excel defaults to this setting if a cell contains both text and numbers.

**Scientific** formats numbers in **scientific notation**.

For example, if you enter **140000** into the cell, then the cell will display the number as **1.40E+05**.

**Note**: By default, Excel will format the cell in scientific notation if it is a large integer. If you do not want Excel to format large integers with scientific notation, use the **Number** format.

**Fraction** formats numbers as fractions separated by the **forward slash**.

For example, if you enter **1/4** into the cell, the cell will display the number as **1/4**. If you enter **1/4** into a cell that is formatted as **General**, the cell will display the number as a date, **4-Jan**.

**Percent** formats numbers with **decimal places** and the **percent sign**.

For example, if you enter **0.75** into the cell, the cell will display the number as **75.00%**.

**Long Date **formats numbers as **Weekday, Month DD, YYYY**.

For example, it would appear in this format: **Monday, August 01, 2010**.

**Time** formats numbers as **HH/MM/SS** and notes **AM** or **PM**.

For example, it would appear in this format: **10:25:00 AM**.

**Short Date** formats numbers as **M/D/YYYY**.

For example, August 8th, 2010, would be **8/8/2010**.

**Accounting** formats numbers as monetary values like the Currency format, but it also **aligns** currency symbols and decimal places within columns. This format will make it easier for you to read long lists of currency figures.

**Currency** formats numbers as **currency** with a **currency symbol**.

For example, if you enter **4** into the cell, the cell will display the number as **$4.00**.

**Number** formats numbers with **decimal places**.

For example, if you enter **4** into the cell, the cell will display the number as **4.00**.

**General** is the **default** format for any cell. When you enter a number into the cell, Excel will **guess** the number format that is most appropriate.

For example, if you enter **1-5**, the cell will display the number as a Short Date, **1/5/2010**.