Formatting Money and Percentage Values

I mentioned earlier that you can use the Format Cells dialog box to specify the number formatting for cells. Formats for money and percent values are most important for the topics of later chapters, so let’s take a look.

The percentage number format multiplies the value by 100 and displays a percent sign. For example, the value 0.03 would be displayed as 3%. The only option you have with this format is the number of digits displayed to the right of the decimal point.

Currency format is ideal for most money values. It has several options (shown in Figure 2.5):

• The currency symbol used (the default is the symbol for the current locale)

• The number of decimal places displayed

• Whether negative values are displayed with a leading minus sign, in red, or in parentheses

The accounting format is the same as the currency format except for three things: Negative values are always displayed in parentheses, values in a column are lined up on the decimal point, and the currency symbol is displayed just to the left of the number rather than at the left edge of the cell.

Taken From : Manage Your Money and Investments with Microsoft Excel

Related posts:

1. Calculating Loan Payments (3) In most situations you omit both of these optional arguments....
2. Working With Future Value (2) The other two arguments are optional: pv is the present...
3. Excel and Money Excel has a number of features designed specifically for working...
4. Using the Present Value Function (2) You use the PV function to calculate present value. The...
5. Calculating Interest Rate (2) The other three arguments are optional: fv is the future...

Related posts brought to you by Yet Another Related Posts Plugin.