Premium Content You need a subscription to comment. I have tried all kinds of formats on numbers and can not stop Access from scientific notation. Joined Feb 15, 2007 Messages 355. Is there anyway to totally disable scientific notation in Access 2007 Comment. OssieMac: Thanks for the reply. This option is supported for integral types (Byte, Short, Integer, Long) only. Yeesh. To walk you through my steps, I. The users don't want to have to re-format the doc each time they go in. Opened a new workbook Selected first 5 columns formatted cells to text imported from web to current sheet. D, or d: Displays number as a string that contains the value of the number in Decimal (base 10) format. These values are then copied into an .xls file to be used in calculations. Removing Scientific Notation in Excel cell. So, you will express the movement with an E. In scientific notation 183857.419 becomes 1.83857419E+5 as for this number, the decimal point has moved 5 digits left. I use Excel 2000, and have just tried it again. 9612019086568871420292. All of the numbers are Double or Decimal. Dave, I'm just not having the luck you are. I have bunch of 22 digits numbers, e.g. Start Free Trial. Re: Stop Auto Format To Scientific Notation. Example. I would think that scientific notation should be universal--well, there ought to be some number format that works everywhere--but that's probably too much to hope for. The problem is that I can't format cells in the .csv file as text, but they are formatted as general. This example shows various uses of the Format function to format values using both named formats and user-defined formats. Specifically When the user views the the columns the longer numbers all display in scientific notation. I tried this and after the last step, when I go back and open the .csv file the column I removed the " from and changed to format 000000000000 is changed back to General and some of the cells are back to scientific notation, e,g, 1.12345E+11 So, the scientific notation is 7.245E+3, +3 as the decimal point has moved left. Good grief. Ok, trying it now, I see that they are. Cells formatted as general use scientific notation for numbers with more than 12 digits. The users double-click .csv file and it launches Excel and opens the doc. In scientific notation, this small number, 0.00007245 becomes 7.245E-5. Are numbers in scientific notation locale specific? Join Date 06-20-2007 Location The Great State of Texas MS-Off Ver 2003, 2010 Posts 40,655 Hello, I have a machine control system that writes hexadecimal values into a .csv file. Thread starter sjha; Start date Feb 21, 2007; S. sjha Active Member. when I do this, some cells are changed to scientific. Re: [Solved] Prevent auto formatting to scientific notation by peterroots ยป Sun Jan 15, 2012 9:34 pm you never mentioned you were saving as csv - that is not a spreadsheet file that is a text file - formatting is not saved like in a spreadsheet but stuff will be in there as you entered it. For example, Format(1234567, "e") returns 1.234567e+006. Uses standard scientific notation, providing six significant digits. Feb 21, 2007 #1 Ladies and Gentleman, I have tried to serach this forum but could not find what I need.