EXCELUsing Scientific Notation in Custom FormatsTo 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:
Click here to return to the Excel index. |