Insert More Than 16 Digits In Excel Cell

Yesterday I got a phone call from my friend. He asked me he was trying to enter some serial numbers of SIM cards in excel cell. Those numbers were of 19 digits length. He told me, the digit of sixteenth place and onwards changed to zero. I tried the same. He was right.

To overcome the issue I changed the cells format to text rather than number. It worked. Now if you enter number containing more than 15 digits it remain same as you entered. Because the value you entered is now considered as a text.

clip_image002

But the only problem is that you can not make any calculations using these cells. But you have managed to enter long numbers like credit card number etc.

6 thoughts on “Insert More Than 16 Digits In Excel Cell”

  1. I have to say this issue that doesn’t allow more than 16 digits in excel totally sucks. The only way I guess is to add ‘ in front of the number. Lame, lame and lame!

  2. i am distributor of videocon sim ..
    so I also faced this problem

    thanks for this ….

    very nice and useful in excel..

Comments are closed.