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.


Posted

in

by

Comments

6 responses to “Insert More Than 16 Digits In Excel Cell”

  1. azhar

    Nice piece of information, I like this

  2. Apara

    It is also not working and in at last it turn into 1.234443245522+1312.

  3. me

    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!

  4. venu

    very nice. thank you very much.

  5. VIPIN

    i am distributor of videocon sim ..
    so I also faced this problem
    thanks for this ….
    very nice and useful in excel..

  6. afzal

    Sir, I have a problem to write a number starting from zero in Exel.