Left 0 elimination

[ljimenezvega84]

Hi everyone, i´ve got a column wicht has 000 on the left. Im trying to eliminate changing the data type from text to decimal and whole numer but its gives me an error. Exists any formula to eliminate those zeros?

Thanks

[ljimenezvega84]

Thanks MasonMA

regards

[MasonMA · Accepted solution]

Hi, there are different ways to handle those leading zeros. One of them is adding a Custom Column in Power Query with Text.TrimStart function as in the attached picture.