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.
2 Replies
The simplest solution is probably to convert the column to a whole number data type instead of text.
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.
