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.

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×