Text Formula Returns Many Leading Zeroes Sometimes

[doofenshmirtz]

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

[bebo021999]

If "1234567" is a single text-number, excel treats it likes a number
But with string "1234567, 12345678,..." it likes real Text string, not number

[vba_php]

are you saying that you have an actual number in any given cell that is 164 characters (bytes) long? that would be a string literally like this (chars instead of numbers):

Please Login or Register  to view this content.

you might want to take a look at this following link. it seems as though the behavior that's annoying you is default behavior of the program:

https://www.howtoexcel.org/tutorials/leading-zeros/