In excel if we are try to add more numbers (1234567891011123) may be it will show just like this 1.23457E+11 How we can clear it ,, first select the column, then options - format cells- then select the -text- , then ok ... Then double click the column, you can see it as you type...' Enjoy.......