Excel can only handle 15 digit numbers, after that everything gets shown as
0. If you want 20 digits you will have to hold it as text.

--
__________________________________
HTH

Bob

"Sandeep Jangra" wrote in message
...
D'all,
In a column, I hav 16 digits numbers. But when I add 4 digit number after
last digit of that number becomes 4 zeros at last. e.g. 9503170011002910
(16
digit number) 1425 (4 digit number) becomes 95031700110029100000 whether
it
should be 95031700110029101425