Thursday, December 8, 2016

Formats for percentages, exponential notation, and non-U.S. currency

Formats for percentages, exponential notation, and non-U.S. currency

Percentages To display numbers as a percentage of 100, include the percent sign (%) in the number format. For example, a number such as .08 is displayed as 8%; 2.8 is displayed as 280%.

Scientific format To display numbers in scientific format (exponential notation), use "E-," "E+," "e-," or "e+" codes in a section. If a format contains a 0 (zero) or # (number sign) to the right of an exponent code, Microsoft Graph displays the number in scientific format and inserts an "E" or "e." The number of 0's or #'s to the right of the exponent code determines the number of digits in the exponent. "E-" or "e-" places a minus sign by negative exponents. "E+" or "e+" places a minus sign by negative exponents and a plus sign by positive exponents.

Currency To specify one of the following currency symbols in a number format, with NUM LOCK on, hold down ALT and type the ANSI code for the currency symbol on the numeric keypad. For information on other currency symbols, see Help for the program from which you inserted the Microsoft Graph chart.

To enter

Hold down ALT and type

¢

0162

£

0163

¥

0165


Note: Custom formats are saved with the chart. To have Graph always use a specific currency symbol, change the currency symbol selected in the Regional Settings control panel before you start Graph.

No comments:

Post a Comment