Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Washington, USA
    Posts
    79
    Thanks
    0
    Thanked 0 Times in 0 Posts

    06E0 triggers garbage in cell (Excel 2000)

    Input 06E0 in cell and get "6.00E+00"
    07E0 also fails unless "o" is used instead of "0"

  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: 06E0 triggers garbage in cell (Excel 2000)

    What is heppening is that Excel is assuming you are using a scientific notation (exponential) and is so applying the scientific format. You will find in your example that the actual value in the cell is 6 (06E0 = 6). if you enter 06E5 th evalue will become 600,000 (i.e. 6 * 10^5).

    To overcome the problem format the cell as text prior to entering such values or precede the value with a single quote mark ( ' ), which will not display. Or else just use O instead of zero.

    Andrew C

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Washington, USA
    Posts
    79
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 06E0 triggers garbage in cell (Excel 2000)

    Many thanks Andrew!!

  4. #4
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: 06E0 triggers garbage in cell (Excel 2000)

    todora

    I tried this in MS-Excel 2000 on a brand new workbook and it worked OK for me. I tried it using MS-Excel 2000 build 2719 and 2720 with Windows NT 4 with Service pack 4 and 6.

    I guess it is time to clean your workbook...

    HTH

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  5. #5
    Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Washington, USA
    Posts
    79
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 06E0 triggers garbage in cell (Excel 2000)

    Thanks. Wassim!

Posting Permissions

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