Forum Discussion

Aspi's avatar
Aspi
Helper I
5 years ago
Solved

Numbers not being displayed same as in Excel.

Hello all you experts, I have data in Excel that has a number field with 3 digits i.e. leading zeros when . When uploaded into Power BI this field shows with only 1 digit. For example If Excel has 0...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi Aspi 

    Set the Column to Whole Number and set the Format to 000.  Just type 000 into the Format String Area.

    Regards

    Phil

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi Aspi 

Set the Column to Whole Number and set the Format to 000.  Just type 000 into the Format String Area.

Regards

Phil

Aspi's avatar
Aspi
Helper I
5 years ago

Hi Phil,

Thanks for the advise. It has worked perfectly... Great.