Forum Discussion
Solved
Delete numbers
Hi, I want to delete the number '0' before the integers. Thanks!
Hi dolevh ,
Try to add a custom colum in power query
= Text.TrimStart([Column1],"0")Reference: Remove Leading Zeros from Text in Power Query - YouTube
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The simplest solution is probably to convert the column to a whole number data type instead of text.