Excel: Excluding the Plus Sign from Scientific NotationLast reviewed: November 2, 1994Article ID: Q63260 |
SUMMARYWhen formatting a number to appear in scientific notation, the number appears with a plus sign (for example, 12E+5). To change this format, do the following:
For more information on formatting numbers, see pages 180-182 in the "Microsoft Excel User's Guide" version 3.0 manual. If you are using Excel 2.20, see pages 303-308 in the "Microsoft Excel Reference" version 2.2 manual.
|
KBCategory: kbother
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |