Hi,
On Excel, numbers must conform to IEEE 757 standards of 15 characters or less, any digit beyond 15 is replaced by "0".
That's why you need to treat numbers with more that 15 chars as text.