Forum Discussion
Solved
Prevent Scientific Notation
I'm dealing with some ID numbers that show up fine in Excel but get converted to Scientific Notation whenever I import them in PBI, which also changes the numbers for some reason. Is there any way to...
Just started working actually, I added a * to the column in excel and then removed it in PBI!
I have a text file with chess moves such as 1.e3 which kept getting changed to scientific notation.
I changed all the e's in my file to é (e acute) and on importing to excel it left them alone!
I don't care if 1.e3 looks like 1.é3