Forum Discussion
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...
I just experimented with this. I left the numbers in scientific notation in Excel. I imported into Power BI. Power BI displayed them in scientific notation but the underlying data was their actual numbers. Converting to text displayed them as their full number values.