Forum Discussion
angelakephart
6 years agoHelper I
text to decimal conversion returns scientific notation for some numbers
I have a csv file that has a column that starts as a text column but is converted to a decimal. I trim and clean the column before I promote the header and change the type to decimal. For the numbe...
Anonymous
6 years agoNot applicable
Hi angelakephart ,
You can see these solutions
https://www.myonlinetraininghub.com/excel-forum/power-query/numbers-turn-scientific-in-power-query
https://community.powerbi.com/t5/Desktop/scientific-notation/td-p/302089
https://community.powerbi.com/t5/Desktop/How-to-stop-scientific-notation/td-p/564430
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)