Forum Discussion
Solved
Left 0 elimination
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...
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.
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.