convert number 1,4441E+16 to decimal

[emveha]

hi

am using a xls file as source for PBI and in one of the columns i have numbers which looks like

1,4441E+16 of course the other numbers look "normal" like 133.32 .

the question is how can i convert this 1,4441E+16 to a decimal number....

hope you can help me out on this.

grazie

vd

[rocky09]

did you try to  import into Power BI and see how the data is showing?

[emveha]

See below  a small overview of items which needs to be converted, if you upload them in PBI you have the same issue as in xls...

Date               Sales

21-2-2019       133.32

22-2-2019       483.50

23-2-2019       2,5667E+16

24-2-2019       1,4441E+16

25-2-2019       5,6443E+15

26-2-2019       111.18 

[rocky09]

can you please upload a sample data in excel file?

[emveha]

how can i upload file in here???

---

@rocky09 wrote:

can you please upload a sample data in excel file?

---

[rocky09]

you can share via google drive or one drive etc..

[emveha]

https://1drv.ms/f/s!Aq1CMo1k4ovJlX3vI0E8BlGUQxe-

[rocky09]

@emveha 

sorry for the delay in response.

I have just changed the format from the General to Number and all set. 

[emveha]

hi Rocky,

again thanks for helping out on this topic, the issue is that by changing the format of the field in xls, it does not solve anything. As soon as you upload this file with the new values to Power Bi you still have an nr that looks like 14441E+16 despite the changes on the format.....

[rocky09 · Accepted solution]

@emveha  even, if you see those numbers like 14441E+16. Just ignore and place on it on the visuals. You can see the Proper Numbers. You may need to play with the formatting setting under Model Tab.