Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2001
    Location
    Virginia, USA
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Custom Number Format - Scientific Notation (Excel 2002/SP-2)

    A user upgraded from Office 97 to Office XP. Most of her Excel files contain data formatted in scientific notation. She had custom formatted the cells to display a lower case 'e" instead of the default upper case 'E'.

    When she opens one of these files in Excel 2002 she gets a pop up window stating, "File error. Some number formats may have been lost". Clicking on OK opens the file but some cells that were custom formatted do not have the scientific notation and other cells just have the upper case 'E'.

    It is possible to format the cells in Scientific Notation and display them properly with the upper case 'E'. When you try and custom format the cells and use a lower case 'e' the following pop up window is displayed, "Microsoft cannot use the number format you typed. Try using one of the built-in formats. In the Format menu, click Cells, and then click the Number tab. Select the category you want, and then choose other options. For more information about custom formats, click Help." Clicking the help leads you to a discussion specifically showing the use of lower case 'e' in the custom number format.

    This is only happening in Excel 2002. Excel 97 and Excel 2000 work properly and the user can customize as desired.

    Is there a workaround or have I found a bug or a new feature.

    Thanks.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Custom Number Format - Scientific Notation (Excel 2002/SP-2)

    You should be able to display numbers with the a capital E by using the Scientific notation from the category list in the format Number dialog.

    XL2002 seems to ahve a problem wit a lower case e, and it seems to be a bug.

    Andrew C

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •