Forum Discussion
format the number
Hello, everyone
How can I format the number 1.00054E+16 to 1.00054 in Power Query or with a DAX function.
Thanks
10 Replies
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-daxHi,
It does not work
originals:That's weird. Does the ROUND function work?
or....
VALUE(FORMAT())?
doesn't work because i have a scientific number
1,00054E+16 to 1,00054 *****
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?
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
