Forum Discussion

ktt777's avatar
ktt777
Icon for Helper V rankHelper V
6 years ago
Solved

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 
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    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.

     

     

     

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
6 years ago

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.