[TABLE="width: 163"]
<TBODY>[TR]
[TD="align: right"]7.20576E+16
[/TD]
[/TR]
[TR]
[TD="align: right"]7.20576E+16
[/TD]
[/TR]
</TBODY>[/TABLE]
[....]
This is what it shows in the column , the file itself is in CSV format , i just need it to expand
I'm sorry, but that is not very clear.
First, open the CSV file in Notepad. Do the numbers look like you require, for example 1234567890123456? Or do they look like 1.23456E+16 or 12345600000000000 (11 zeros) or 1234567890123450 (16th digit is always 0)?
If the latter, your data is already corrupted, and there is nothing you can do to correct it. You must start over with the original data.
Second, what is this data? Are they truly numbers that you might use in computation? Or are they really identifiers that we call "card number", "product number", "employee number" etc because they look like numbers?
If the latter (identifiers), the data should be entered
as text to begin with because Excel has arbitrary data entry and formatting limitations that affect true numbers with more than 15 significant digits, like 7.20576E+16.
Do one of the following to enter the data as text: (a) format the cell as Text beforehand; or (b) enter '1234567890123456, with a leading single-quote, aka an apostrophe; or (c) enter the formula ="1234567890123456".
But even if the data is entered as text initially, limitation #3 below still applies when a CSV file is opened in Excel.
-----
If the data are true numbers that you might use in computation, you are playing with fire when you have such large numbers. Bear in mind the following limitations:
1. The computer can only represent 16-digit integers up to 9,007,199,254,740,992 exactly, due to the way that Excel stores numbers (64-bit binary floating-point).
2. Excel formats only the first 15 significant digits, rounding the 16th digit. So if the result of a calculation is 1,234,567,890,123,456, it
appears as 1,234,567,890,123,4
60 when formatted as Number, even though it is
truly stored as 1,234,567,890,123,4
56.
And the value saved to a CSV file will be 1,234,567,890,123,4
60 because it is saved
as it appears in the cell.
This limitation is only for numeric values, not text. So if 1234567890123456 is text (ISTEXT returns TRUE), then 1234567890123456 is saved to a CSV file, again because it is save
as it appears in the cell.
3. When entering data, Excel interprets only the first 15 significant digits, replacing any digits on the right with zero. So if you type 1,234,567,890,123,456, the numeric value will be exactly 1,234,567,890,123,45
0, not 1,234,567,890,123,45
6.
This limitation applies when you
open a CSV file, even if the CSV data looks like "1,234,567,890,123,456" or "1234567890123456". Excel removes the double-quotes and interprets the string as
the number 1,234,567,890,123,45
0.
This limitation does not apply when you
import a CSV file
and select Text for the column format in import Step 3. Excel removes the double-quotes and interprets the string as
the text 1,234,567,890,123,456 or 1234567890123456.
But that presumes the data looks like 1234567890123456, "1,234,567,890,123,456" or "1234567890123456" when you open the CSV file in Notepad.
-----
If you need further assistance, I suggest that you upload example Excel and CSV files to a file-sharing website and post the share/public URL in a response here.
The Excel file should contain the original data before you save to a CSV file, not data that you opened as or imported from a CSV file.
The CSV file should contain the data saved as CSV from Excel with the original data.
