also @ TechSpot: Apple iOS 'Absinthe' jailbreak: 1 million downloads and counting

TechSpot

Excel can't add....

Discussion in 'General Discussion' started by nickslick74, Sep 28, 2007.

Thread Status:
Not open for further replies.
  1. nickslick74 Newcomer, in training

  2. halo71 Newcomer, in training

    That is pretty interesting! lol
  3. hynesy Newcomer, in training

    lol excel, funny how one specific multication causing problems.
  4. Daveskater Banned

    that's quite funny :D

    i wanna try it haha

    i just gave it a go and it came up with 100000
    brilliant stuff

    [IMG]
  5. AlbertLionheart TechSpot Chancellor

    Now I know why I stuck with Lotus 123 all these years.
  6. Daveskater Banned

    i don't blame you ;) good ol' microsoft getting it right again
  7. AlbertLionheart TechSpot Chancellor

    Just checked OpenOffice Calc - that works OK.
    The more I think about this, the weirder it is - first that MS could let this go for so long - but also that it has taken someone so long to find it!
  8. Daveskater Banned

    the chances of someone finding this particular problem must be fairly low because it's such a random number and it involves multiplying decimals, unless it was just some sort of test

    it's not often i need to get the number 65535 in my spreadsheets ;)
  9. AlbertLionheart TechSpot Chancellor

    I googled it and found all sorts of stuff, including
    "65535 is a frequently occurring number in the field of computing because it is the highest number which can be represented by an unsigned 16 bit binary number".
    It is also a Mersenne number according to wiki.
    Amazing!
  10. Daveskater Banned

    wow, turns out it's not as simple as it first seems

    an innocent number turned into the highest unsigned 16 bit binary number

    who'da thunk it?
  11. LuckyM Banned

    i just wonder what will book-keepers do if companies they work for use excel...
Thread Status:
Not open for further replies.