Forum Discussion

Tito's avatar
Tito
Icon for Helper IV rankHelper IV
3 years ago

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
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

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?

Tito's avatar
Tito
Icon for Helper IV rankHelper IV
3 years ago

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