Hi,

Most of the time, my formula returns the expected result.
But on one instance, it does not whhere the original string is 164 characters long

Most of the time, i have a simple number like 12345678 in F2
I use a formula to convert it to text : =Text(F2,REPT("0",LEN(F2))) which returns 12345678 as text.

However, I also have a 164 character string that looke like 1234567, 12345678, 1234567, ....
In this instance, my formula is returning 0000000012345678000000....

Any thoughts as to why?

Thanks,
-w