Is it possible or not?

when i write 12345678912345678912345 in a cell i got displayed this “1.23457E+22” or “12345678912345600000000.00”. it shows zeros after 15th digit. so is it possible to make it display fully like i wrote in a first place.
thanks in advance
Answer #1
Yeah it seems that Excel can only handle 15 digits… anything above that, and it can only round it up.
There might be some sort of add-on that Microsoft do, that maybe you can download – like a patch as such.
But your best bet would be to ask someone over at the Microsoft Excel forum.
http://www.excelforum.com/
Answer #2
It display’s fine for me on Excel 2010.
Answer #3
so i got solution on http://www.excelexperts.com. before i write the number i have to change number format to “text” then it displays all numbers but i got another problem. i have tones of data written in above mentioned way. Does this mean i will have to re-write all of them again or is there a magic way to change them all together?