Click here for great value web hosting.

ALL ABOUT OFFICE

HOME

ACCESS

EXCEL

WORD

OUTLOOK

POWERPOINT




Search for
 

help


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