scientific notation

I have daily .txt reports that I would like to import into excel as separate sheets in the same workbook. My problem is that 3 of the 4 files have fields that are numbers that are 20 digit account numbers and import as scientific notation. I want them import as text. I am currently using the...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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" &...