Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    Mar 2003
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Large numbers in cells (Excel 2000)

    Hi all,

    I'm using a set of cells that displays the results of a multiplication (formatted in currency). The numbers only seems to show up to $999,999.99 but some of the calculations gives numbers in the millions. After $999,999.99 the cells just shows ########. Is there a way to show the million dollar results too?

  2. #2
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Large numbers in cells (Excel 2000)

    Make the column wider!!

    Peter

  3. #3
    Star Lounger
    Join Date
    Mar 2003
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Large numbers in cells (Excel 2000)

    yes I am a dummy! LOL.... I can't believe I didn't realize that, never mind me!!! (what a way to start my day!!!!)

    Thanks

  4. #4
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Large numbers in cells (Excel 2000)

    <img src=/S/newbrain.gif border=0 alt=newbrain width=21 height=22> It gets to us all at times <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Even with wider columns I think that you will only get the first 15 digits, after thats it all zero's

    Peter

  5. #5
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Large numbers in cells (Excel 2000)

    Just out of interest here, what's the best way of dealing with (very) large number formats? Something like barcodes or account numbers for instance. Obviously you could revert to text, but what if you need numerical?

    Alan

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Large numbers in cells (Excel 2000)

    Excel simply doesn't support more than 15 significant digits; this is a limitation imposed by the way numbers are stored:
    <hr>Double (double-precision floating-point) variables are stored as IEEE 64-bit (8-byte) floating-point numbers ranging in value from -1.79769313486231E308 to -4.94065645841247E-324 for negative values and from 4.94065645841247E-324 to 1.79769313486232E308 for positive values.<hr>
    If you need to store numbers with more than 15 significant digits, store them as text, or use a dedicated financial application.

  7. #7
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Large numbers in cells (Excel 2000)

    Thanks Hans. Text is not that bad actually, since sorting etc. is still viable.

    Alan

Posting Permissions

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