cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pierre415
Helper I
Helper I

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 prevent scientific notation? I've tried changing the column format to text but it doesn't make a difference. 

 

Thanks,

Pierre 

1 ACCEPTED SOLUTION

Just started working actually, I added a * to the column in excel and then removed it in PBI!

View solution in original post

8 REPLIES 8
bgale1945
New Member

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!

bgale1945
New Member

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

bgale1945
New Member

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

Greg_Deckler
Super User
Super User

I'd like to play around with that, how big does the number have to be in Excel?


@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Learn Power BI 2nd Edition

Just started working actually, I added a * to the column in excel and then removed it in PBI!

@pierre415,

 

Glad to hear that you've solved this problem. You could help accept it as solution. Your contribution is highly appreciated.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

We have a similar problem. Some zeros in Tables and Matrices appear with scientific notation, dispite being set to Integer.

We solved it by rounding to two decimals with ROUND([measure], 2), and then changing the format to 'Whole number' in the Modelling tab.

BK
Frequent Visitor

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

Power BI Dev Camp Session 22 without aka link and time 768x460.jpg

Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Kudoed Authors