Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

Stop Excel from changing large "numbers" (actually text values) to scientific notation.

Prevent Excel from changing large "numbers" (actually text values) to scientific notation.

1,333 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Caleb shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    386 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • scrispin commented  ·   ·  Flag as inappropriate

        every time you open a .CSV file with unsigned integers saved in it in Excel it changes it back to scientific notation and there appears to be no way of turning this off. This is insane

      • Anonymous commented  ·   ·  Flag as inappropriate

        I am so angry right now (all my products are no longer on google because of the upc's turned into your handy scientific **** - thanks GUYS!) that I could punch a kitten in the face.... and i LOVE kittens. Don't you guys love kittens? if so, lets prevent kitten punching BY GETTING RID OF THIS ****.

        :-(

      • Anonymous commented  ·   ·  Flag as inappropriate

        Every single time I have a UPC this messes up EVERYTHING
        every time I have a tracking number - SCIENTIFIC

        WHO THE **** IS USING THIS SCIENTIFIC **** ANYWAY?!?!?!?!?
        I'd think there are FAR more people who need long numbers for say TRACKING OR UPCS

        so dumb - I hope the genius who came up with this *** is no longer with you guys because they are STUPID AS ****

      • i once was zak, but now i'm zak commented  ·   ·  Flag as inappropriate

        i'm personally really sick of technology that tries to "outsmart" us. people who aren't aware of it often get confused, and those of us who ARE aware of it often don't need or don't use it.

        it should be OFF by default, and can be turned on if we feel the need to dig deeper...

      • Scott McGee commented  ·   ·  Flag as inappropriate

        I'm actually okay with MS trying to save us time. But you've got to allow us to set a default that bypasses or turns off the time saving idea. Kind of like getpivot. D'oh! Yeah, I've heard some in Redmond thing that's cool. But - you're the only ones that do! LOL

      • Amy commented  ·   ·  Flag as inappropriate

        Best Comment EVER!
        Agreed!
        This so called "feature" causes me to lose data and grief! ugh!

        Anonymous commented · June 13, 2018 19:50 · Flag as inappropriate

        "Whenever you have a "cool, time-saving programming idea", and it involves side effects with user's data, punch yourself in the face and dump a bucket of cold water over your head. Then don't write the code."

      • Bruce commented  ·   ·  Flag as inappropriate

        Whenever you have a "cool, time-saving programming idea", and it involves side effects with user's data, punch yourself in the face and dump a bucket of cold water over your head. Then don't write the code.

      • FaucetFool commented  ·   ·  Flag as inappropriate

        Hey it's been 3 years and there's no feature for this. The amount of times that it deletes info while working, even when converting the cells to text. How long until we can just disable Scientific notation. I have no purpose for it in my line of data entry yet I use a lot of number heavy text cells.

      • Anonymous commented  ·   ·  Flag as inappropriate

        For me, a download of a file in CSV format, where a field may store 8154E09, if SAVED with a .txt extension, opens in Excel through the import wizard and specifying CSV, with the text value and not scientific notation. I could see in Notepad that the extract kept the text intact before Excel could corrupt it.

      • i once was zak, but now i'm zak commented  ·   ·  Flag as inappropriate

        that's a valid thought David. i mean, if somebody was ACTUALLY using Scientific Notation, don't you think they would actually type it out as 6.352E+13 , as opposed to typing out a long string that will ultimately be truncated?
        it seems to me that Microsoft is merely taking the shortcut from actual coding by just taking any long number and truncating it...
        also, i vote that we call it "S.cientE+17" from now on, since people will obviously be able to tell what that means...because who doesn't prefer truncated information to the actual data?

      • David commented  ·   ·  Flag as inappropriate

        Wondering how many users actually PREFER numbers to be changed to scientific notation by default... ? I would guess the minority. One more thing: when you implement this change, if a value is too large to store as a number (> 64 bits or whatever) then please don't change the least significant digits to 0s -- store it as a text value. I know--that will make us lose the ability to do mathematical operations. That's OK; at least the data is still accurate.

      • Emily commented  ·   ·  Flag as inappropriate

        This has happened to me about 5.00E+15 times and it's so annoying!

        Vote # 1.269E+3 here

      • i once was zak, but now i'm zak commented  ·   ·  Flag as inappropriate

        yeah, I realize that 1,248 doesn't sound like much, compared to how many people there are in the world, but not EVERYBODY uses Excel.
        and if you want to pull MORE people to use it, why not make it useful, instead of useless?

      • Mark Heuckeroth commented  ·   ·  Flag as inappropriate

        If you are uncautious and save a CSV file you just opened, Excel literally destroys your numeric data. How can this be possible in a flagship product?

      ← Previous 1 3 4 5 19 20

      Feedback and Knowledge Base