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 stopped excel changing things like 1.e3 by changing all the e's in my input text file to é (e acute). It worked!
I don't really care if 1.e3 shows as 1.é3