5/31/2023 0 Comments Excel 13Bear in mind the following limitations:ġ. ![]() If the data are true numbers that you might use in computation, you are playing with fire when you have such large 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.ĭo 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".īut even if the data is entered as text initially, limitation #3 below still applies when a CSV file is opened in Excel. 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? You must start over with the original data. ![]() If the latter, your data is already corrupted, and there is nothing you can do to correct it. You can do that directly in Get External Data > From Text instead of formatting the cells beforehand.įirst, open the CSV file in Notepad. In that case, the cells or column should be formatted as Text. I suspect that "numbers" with that many digits are really identifiers which you do not intend to use in arithmetic for example, account "numbers". However, that might be tedious to do, especially if your column data have mixed formats. You can work around that behavior by formatting the cells as Number with zero decimal places first, then use Data > Get External Data > From Text to import the CSV file. When the cell format is General, Excel displays any number with more than 11 digits in Scientific form, regardless of the cell width. ![]() ![]() The problem is: whenever you open the CSV file in Excel, Excel will reinterpret the data as if you typed it manually, and it sets the cell format to General.
0 Comments
Leave a Reply. |