Forum Discussion
Solved
Number formatting with Specific Text Length
Im having set of data with differnt lenght (5/6/7/8/9/10 etc) i would like to bring on common lenght funtion everyting len = 11 charrector by using power Query.
Insert a custom column named Update Code and put following formula
= Text.PadStart(Text.From([Code]),11,"0")
1 Reply
Insert a custom column named Update Code and put following formula
= Text.PadStart(Text.From([Code]),11,"0")