Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to stop scientific notation

I am loading Excel data into Power BI. This data has ID columns which have large numbers. Excel converts these to scientific notation by default. I can convert them into regular numbers by formatting...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Hi aabi01,

 

You may try function below in power query and check if the column value can be changed to text format. 

 

=Number.ToText(Number.From())

Regards,

Jimmy Tao