Forum Discussion

pierre415's avatar
pierre415
Icon for Helper I rankHelper I
9 years ago
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...
Need Help
bgale1945's avatar
bgale1945
New Member
8 years ago

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