# EXCEL
### Using Scientific Notation in Custom Formats
To display numbers in scientific
format, use "E-," "E+," "e-," or "e+"
exponent codes. If a format
contains a 0 (zero) or # (number sign) to the right of an exponent code, Excel
displays the number in scientific format and inserts an "E" or
"e". The number of 0's or #'s to the right of a 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.
The following custom formats will
display the number 1,950,000,000,000 in the ways shown below:
**0.00E+00** |
1.95 E+12 |
**0.00E+000** |
1.95 E+012 |
**#.###E+00** |
1.95 E+12 |
**0.000E+00** |
1.950 E+12 |
**Click here to
return to the Excel index.**
webmaster@allaboutoffice.co.uk |