scientific notation

  1. F

    Nbr in E Format Text want to Convert to Scientific Notation and Decimal Equivalent

    I have text in cells: A1 2.11667e-03 A2 2.01168e+02 A3 2.54e-02 I would cells B1,B2, and B3 to convert these text cells to their proper scientific notation. I would also like cells C1,C2, and C3 to convert these scientific notation numbers to their decimal equivalent. What...
  2. J

    Scientific Notation Removes values when converting cell to Number

    Just recently I've run into this issue. Microsoft® Excel for Office 365 MSO (16.0.11328.20362) 32-bit I process data files that have very long alpha/numeric strings and when bringing into Excel, only certain rows display as 2.1E+61. When i change the cell to number format and no decimal, I...
  3. K

    Removing Scientific Notation

    I handle data from different sources. My data has a number with between 1 to 4 decimal places. The usual format the cell to a number does not work for me since my data could be .1 or .10 or .100 or .1000. Simply changing to a number with 4 decimals would change my data. I have tried to...
  4. C

    CSV issues with formatting

    Hi We have recently moved to a new (external) system and in order to load our data we have to send the supplier a CSV file. We create the data in Excel and then Save As CSV. However when you then close and re-open the CSV file many of our numbers convert to Scientific format (things like...
  5. 7

    Text (number) , then csv save changes it back to number

    When I save a text col (all the items are numeric) then save as CSV (MS-dos) it converts the items to numbers. I have a worksheet where I use a Vlookup and IF functions, When IF functions the results are numbers, but in a text form. IN other words the result is coming from a text cell are...
  6. D

    Is there a way to convert "E+02" to text automatically?

    Hi, I have a recurring issue in excel in which when I attempt to import a set of data that has the text "E-00" at the end, it converts to "E+02" or "E+03" automatically. If you know of an easy way to fix this issue, it would be very helpful. My current method of fixing it is to: Insert a...
  7. bepedicino

    VBA Macro Assistance

    I have a spreadsheet where many of the cells contain a scientific notification, I need them to be text cells. I tried changing the format but Excel will not convert the cells unless I double left-click in each cell and then press enter in each of the affected cells. Could someone please assist...
  8. P

    VBA to change room numbers from Scientific Notation to text

    Need help, when we run a report from our work database, and export it to Excel, the room numbers get screwed up because of scientific notation. the Room numbers format are 5 characters in length, characters 1, 3, 4, 5 are numbers, and the 2nd character is a letter. the problem is for all rooms...
  9. P

    Changing to number from scientific notation

    Hello I receive files with account numbers that come to me in scientific notation. the file is already a CSV. Can i change the scientific notation value back to its original number? An example is below This is one of those annoying problems that is putting a project at risk - believe it or...
  10. J

    Another Scientific Notation Quandry

    Greetings I have a report that contains a batch number which is formatted YYMXXX where the month is represented by a single letter. These letters are sequential from A=Jan, B=Feb etc. I don't have a problem manipulating my data until that fateful month of May when my 13E123 suddenly becomes...
  11. D

    Conversion of Scientific notation to Text not working

    Hello, I have a large file with account numbers in Number format. Before I can import the data into a database the account numbers need to be converted to Text. I use Text(A1,0) to do this in a large file. The data then gets copied into a new Import file. When the data gets copied the...
  12. W

    eliminating scientific notation in concatenated cell

    Hi experts, I've searched high and low for a solution to this issue, I'm hoping that someone can help. I have a polynomial equation that I've calculated using a LINEST array. I am trying to output this equation in a specific format for a 3rd party program to process. In order to output the...
  13. 5

    Losing (UPC Code) Leading Zeros when Converting to CSV

    The Situation: Just before the crash, I output the data from our Point of Sale machine, into a TAB delimited formats, and saved them. Ive now spent over 30 days fighting with this .. I need some help please. Problem #1: I keep losing Leading Zeros in my UPC column. The Solution...
  14. L

    Numbers converting to Scientific Formats in .csv files

    I know this question has been asked a bajillion times, so I apologize for the redundancy. I am working with an Excel spreadsheet and saving it as a .csv file in order to upload to an application that parses out the .csv data as transactions. The system requires .csv files, so this is how I need...
  15. D

    Write a large number (16 digits) to a text file

    Column A contains account numbers, which are 16 digits long. Column A is formatted to "0000000000000000". When I Write this out to a text file, Excel tries to help by converting column A to Scientific Notation. Here's the code: While iCounter < iLastRow + 1 Set RngA = Range("A" &...

Some videos you may like

This Week's Hot Topics

Top