format the number

[Tito]

Hello, everyone
How can I format the number 1.00054E+16 to 1.00054 in Power Query or with a DAX function.
Thanks

[Tito]

1,00054E+16 to 1,00054 *****

[Greg_Deckler]

@Tito @PaulDBrown Um, at the risk of pointing out the obvious, 1.00054E+16 is in no way, shape or how equivalent to 1.00054. Like, at all. If you want to get 1.00054 from 1.00054E+16 you are going to need to divide by like 1E+16, right?

[PaulDBrown]

OMG!b you are soo right! LOL!More fool me for assuming the "," was the decimal delimiter (which is so in my whereabouts...). Apologies @Tito 

[Tito]

@PaulDBrown  @Greg_Deckler  
That's right. But the numbers are not only with 1E +16, there is also 1E +15 etc. as a solution I divided the column by 10000000.
Thanks for your help

[Tito]

Hi, 
It does not work

originals:

[PaulDBrown]

That's weird. Does the ROUND function work?

or....

VALUE(FORMAT())?

[Tito]

doesn't work because i have a scientific number

[PaulDBrown]

Are the original columns set as type decimal number?

Otherwise, in Power Query, use the Extract option in the ribbon and select 7 for number of characters and then format as a decimal number

[Tito]

General number:


decimal number: 

[PaulDBrown]

You can establish the decimal places in the formatting options in the ribbon:

 Or you can use the ROUND function In DAX:
https://learn.microsoft.com/en-gb/dax/round-function-dax