Number formats: currency, accounting, percent

In this lesson

1. 1. Currency

   A number format changes how a number looks. It does not change the value.

   The currency format adds a money sign and two decimals.

2. 2. Percent

   The margin in C4 is a decimal. Show it as a percent.

3. 3. The value stays the same

   C4 now looks like 22%. But the value inside is still 0.216.

   Formulas always use the full value, not what you see.

4. 4. Number with commas

   This format shows commas between thousands and two decimals, with no money sign.

5. 5. Accounting

   Accountants often use the accounting format.

   It puts the money sign at the left edge, so the signs line up.

6. 6. Try it yourself

   The tax rate in D2 is also a decimal.

Part of Excel Essentials. Short lessons with practice in a real spreadsheet, checked as you go.