Forum Discussion
All characters after 15 characters getting converted into zeros after changing data type to text
Hi, I have numbers in excel (data source). Numbers are of various lengths. In all numbers where characters are more than 15, automatically zeroes appear, replacing any characters present in the o...
serpiva64
Solution Sage
Solution SageHi,
this is what you get by adding a custom column
= Table.AddColumn(Source, "Custom.1", each if Text.Length([Column1]) <= 15 then [Column1] else Text.Start([Column1],15)& Text.Repeat("0",Text.Length([Column1])-15))
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!