Forum Discussion
Cleaning data
hi all,
how can remove '00 and 00 or 000 at the front of project code
'0040015= 40015
0040015= 40015
00040015= 40015
thanks
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 ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
ktt777 , one way is to change data type to number
Also, refer to
https://www.absentdata.com/power-bi/remove-leading-zeros-power-bi/
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 ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
