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 like 1.e3 which keep getting changed to scientific notation.
I changed all the e's in my text file to é (e acute) and on importing into excel it left them alone.
Having e acute instead of e is a small pice to pay!