EXCEL - limited numbers within cell !!

Discussion in 'Technical Support / Computing / Gaming' started by johnniericoh, Aug 11, 2016.

  1. johnniericoh

    johnniericoh Active Member

    Joined:
    Mar 11, 2011
    Messages:
    1,348
    Likes Received:
    9
    when entering 11 numbers in cell say 11111111111 it is acceptable but if I enter 12 numbers the cell reads 1.11111E+11

    Why
     
    Last edited: Aug 11, 2016
  2. Otis

    Otis Well-Known Member

    Joined:
    Mar 26, 2011
    Messages:
    37,398
    Likes Received:
    18,199
    What??
     
  3. skybluesam66

    skybluesam66 Well-Known Member

    Joined:
    Mar 29, 2011
    Messages:
    2,467
    Likes Received:
    191
    probably Data/Validation
     
  4. Ian1779

    Ian1779 Well-Known Member

    Joined:
    Dec 6, 2012
    Messages:
    2,959
    Likes Received:
    661
    Probably some cell setting that converts to SF after fixed amounts of characters.
     
  5. skybluesam66

    skybluesam66 Well-Known Member

    Joined:
    Mar 29, 2011
    Messages:
    2,467
    Likes Received:
    191
    just click on the , on the tool bar and will correct (or change formats in number formatting)
     
  6. johnniericoh

    johnniericoh Active Member

    Joined:
    Mar 11, 2011
    Messages:
    1,348
    Likes Received:
    9
    thanks for reply but could you be more specific ie which tool bar etc
     
  7. stupot07

    stupot07 Well-Known Member

    Joined:
    Mar 20, 2011
    Messages:
    21,805
    Likes Received:
    6,302
    You have to change for cell format from "general" to "number". You can do this by right clicking on thr cell, choosing format cell and changing it there, or dependent on thr version, there is an option in the toolbar (can't remember which tab)

    Sent from my SM-G930F using Tapatalk
     
  8. olderskyblue

    olderskyblue Well-Known Member

    Joined:
    Mar 22, 2011
    Messages:
    1,655
    Likes Received:
    666
    As was said above, its the , button in the tool bar
     
  9. Covstu

    Covstu Well-Known Member

    Joined:
    Aug 17, 2008
    Messages:
    8,355
    Likes Received:
    499
    column width usually. Double click inbetween the columns and it will automatically align
     

Share This Page