When the user views the the columns the longer numbers all display in scientific notation. Within Excel the single quote is ignored as far as the field data is concerned - for instance, … prevent Excel from converting string to exponential notation. Simply select the cell where the scientifically noted number sits. So, Excel automatically turns a number in scientific notation if the cell width is not sufficient for the number. If you have a scientific notation in the A1 cell you cant just use this formula to have a text formatted value in the B1 cell: =CONCATENATE(A1) This is an example of the results: Excel automatically tries to interpret the cell as having a Any time you need a new CSV file, open the Excel template, make adjustments, and then save a new version as the CSV. Joel,we have a separate application that creates the .csv files, and don't have a choice of using .txt files instead. Stop Excel from Changing Numbers to Dates or Scientific Notations. For example, "879860004073" is converted to "8.7986E+11". Convert scientific notation to text with Kutools for Excel If you have installed Kutools for Excel , you can use the Convert between Text and Number feature to finish this job. So within Excel the field will always display correctly, and if the colum is ever exported to a CSV it will be exported as text and not converted to scientific notation. The users double-click .csv file and it launches Excel and opens the doc. I know what this notation is and I know the various ways to convert this number to text. By default, when you enter a number over 12 digits in an Excel spreadsheet, it auto-corrects the number to scientific notation for brevity. > --> JR Wireless > > "JE McGimpsey" wrote: > > > Does saving the file to csv really convert it to scientific notation Prevent excel from converting to scientific notation csv c#. How can you do that? Kutools for Excel : with more than 300 handy Excel add-ins, free to try with no limitation in 30 days . However, Power BI still auto converts them into nonsense. If I change it to .xls format, it will remain in > the number format, its only when I convert it to .csv that it forces it into > the scientific notation. > see the scientific notation. We have data with lots of product codes that get auto converted to dates or scientific notation. I have an inventory report in Excel 2007 where the SKU numbers appear in scientific notation (I.E.6.13E+11). Sometimes, you might want to stop this auto converting of numbers into scientific notation. Maybe scientific notation is one of the less useful Excel behaviour. Excel Scientific Notation: Disable/Prevent, I think the key issue here is that you are using a CSV, which does not have the cell type embedded in it. This article describes how to prevent Excel from automatically converting a UPC code to scientific notation and corrupting your product catalog. If a number contains leading zeros, the leading zeros are dropped. Turn off scientific notation in Excel. ... the number may be converted to scientific notation, or exponential, format. To prevent the conversion, we import the csv files as text to excel and save as xlsm. Archived Forums > Excel IT Pro Discussions. The worksheet file is a .CSV file.