Forum Discussion

ljimenezvega84's avatar
ljimenezvega84
Icon for Helper I rankHelper I
10 months ago
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 those zeros?

 

Thanks

Need Help
  • MasonMA's avatar
    MasonMA
    10 months ago

    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. 

     

2 Replies

  • MasonMA's avatar
    MasonMA
    Icon for Super User rankSuper User
    10 months ago

    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.