Forum Discussion

rpinxt's avatar
rpinxt
Icon for Solution Sage rankSolution Sage
3 years ago
Solved

Number formatting after excel import

Have on sharepoint this excel file: As you see the config has a leading zero. And that is what I want. I did this with custom formatting in excel not with adding a ' in front of it.   But w...
Need Help
  • rpinxt's avatar
    rpinxt
    3 years ago

    Thanks both but I found the way to fix this in Power BI.

    So formatted it as a whole number and in the model view you can go to formatting in the properties pane.

    Chose your field.

    Set format to custom and for me only had to format it like 00

     

    All good now 😄

     

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

Try to format the config column as TEXT in Excel. After loaded to Power Query, check if the column is converted to number in the step named "Changed Type". You can delete the steps named "Changed Type" added automatically.

  • rpinxt's avatar
    rpinxt
    Icon for Solution Sage rankSolution Sage
    3 years ago

    FreemanZ when I format in excel as Text I again lose the leading zero already in excel.

     

    Will I then get it back in power query?