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.
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.
Insert More Than 16 Digits In Excel Cell
by
Comments
6 responses to “Insert More Than 16 Digits In Excel Cell”
Nice piece of information, I like this
It is also not working and in at last it turn into 1.234443245522+1312.
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!
very nice. thank you very much.
i am distributor of videocon sim ..
so I also faced this problem
thanks for this ….
very nice and useful in excel..
Sir, I have a problem to write a number starting from zero in Exel.