On Nov 4, 10:06*pm, Sandeep Jangra
wrote:
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

If you want to use the number in calculations, you are out of luck.
Excel recognizes only the first 15 digits when a number is entered.

If the "number" is really an identifier (e.g. serial number or tax id)
and it will not be used in computation, you can enter it as text by
prefixing with an apostrophe (single quote). For example,
'95031700110029101425.