A friend of mine has posed the following puzzle and I could not find an answer to it. Hence I am posting it here :
In excel, when you enter a series of digits exceeding 16 digits , you can not see them. If you keep a general format, a,bcde+Y format appears (where Y is the number of digits entered). If we, on the other hand, format it to "number" format, all the numbers after first 15 digits are coverted to '0'.
(Both in MS excel 2003 and 2010).
Why and How to overcome this problem?
I have faith that , as usual, learned friends in this forum will guide me.
Thanks and Regards