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
    Location:
    Coventry
    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:
    41,644
    Likes Received:
    21,921
    What??
     
  3. skybluesam66

    skybluesam66 Well-Known Member

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

    Ian1779 Well-Known Member

    Joined:
    Dec 6, 2012
    Messages:
    3,403
    Likes Received:
    1,271
    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,788
    Likes Received:
    426
    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
    Location:
    Coventry
    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,385
    Likes Received:
    6,875
    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:
    2,049
    Likes Received:
    1,064
    As was said above, its the , button in the tool bar
     
  9. Covstu

    Covstu Well-Known Member

    Joined:
    Aug 17, 2008
    Messages:
    9,119
    Likes Received:
    948
    Location:
    Costa del Cov
    column width usually. Double click inbetween the columns and it will automatically align
     

Share This Page