EXCEL - limited numbers within cell !! (1 Viewer)

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:

stupot07

Well-Known Member
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
 

olderskyblue

Well-Known Member
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

As was said above, its the , button in the tool bar
 

Covstu

Well-Known Member
column width usually. Double click inbetween the columns and it will automatically align
 

Users who are viewing this thread

Top