Cleaning data

[ktt777]

hi  all, 

how can remove '00 and 00 or 000 at the front of project code

 '0040015= 40015

0040015= 40015

00040015= 40015 

thanks 

[v-lionel-msft · Accepted solution]

Hi @ktt777 ,

In fact Power BI will automatically convert your data to number type when you import data columns.

If you want to convert the data type in Excel, it is also very simple.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@ktt777 , one way is to change data type to number

Also, refer to

https://www.absentdata.com/power-bi/remove-leading-zeros-power-bi/