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:
    40,724
    Likes Received:
    21,029
    What??
     
  3. skybluesam66

    skybluesam66 Well-Known Member

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

    Ian1779 Well-Known Member

    Joined:
    Dec 6, 2012
    Messages:
    3,042
    Likes Received:
    744
    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,675
    Likes Received:
    349
    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:
    22,133
    Likes Received:
    6,569
    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,808
    Likes Received:
    806
    As was said above, its the , button in the tool bar
     
  9. Covstu

    Covstu Well-Known Member

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

Share This Page