Delete numbers

[dolevh]

Hi, 

I want to delete the number '0' before the integers. 

Thanks!

[Anonymous · Accepted solution]

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.

[AlexisOlson]

The simplest solution is probably to convert the column to a whole number data type instead of text.