![google sheets cell plain text format google sheets cell plain text format](https://infoinspired.com/wp-content/uploads/2018/01/CELL-function-infotype-example.jpg)
Has the cell display the value in line with it's format (i.e. Hitting Enter or moving the cursor to another location (or hitting 'Tab') If I change the formatting to something else, then change it back to 'Text'Īgain, it still displays in scientific notation! Surprisingly, as I'veĪlready mentioned, selecting the cell, entering 'Edit' mode (F2), then Applying the formatting again makes no difference. This can be confirmed usingįormat | Cells. Not only is there nothing I can see about the original data thatĭistinguishes the data in question from any other numeric string, but theĬells that are displaying the value in scientific notation were alreadyįormatted specifically as 'Text' and still are. Question of how Excel determines what a 'large' number is and whether this Or not depends upon whether you can turn it on or off. If such a function is built into Excel, whether it's helpful If Excel is, indeed, 'trying to be helpful', it's not doing a good jobīecause its behaviour is preventing me from seeing the data as it exists in Or attribute that's affecting the way these numbers are treated? I thought a CSV file was just plain text, but could there be some other data In a text editor to see if there's anything peculiar about these strings, I have also opened the CSV file (that was saved directly from the site) The case, but I can see two 12 digit numbers that have also been converted String was 16 digits or more to be converted to a scientific value. Given what you've said, I'd then expect any numeric value where the This does, indeed, happen as can easily be seen because numbers are rightģ.
![google sheets cell plain text format google sheets cell plain text format](https://i1.wp.com/alicekeeler.com/wp-content/uploads/2018/06/2018-06-28_11-33-56.png)
Value and strings that included spaces or letters to be treated as text. I'd expect any 'numbers only' numeric string to be treated as a numeric Results are the same if I open the file as if I save it then open it.Ģ. Website, but I have the option to either open the CSV file or save it. I have no control over the source data as it comes from my bank's I have done some further investigation and it's raised some interestingġ. I accept that Excel can't handle numbers greater than 15 digits and yourĮxplanation has helped shed some light on the problem, but with this in mind The problem, but I have seen this behaviour before and it would be good toįind out what causes the problem and how it might be avoided/fixed. This isn't really a work-around and doesn't begin to explain the cause of I can't see any other way to '.arrange to have a single quote Work, but then just going to edit the cell fixes the problem without adding I accept that putting an inverted comma at the beginning of the string would Just doesn't display correctly in the cell (except after entering editing Selected, the correct value displays in the editing field at the top. > Special > Values) into the ALREADY FORMATTED sheet.
![google sheets cell plain text format google sheets cell plain text format](https://blog.coupler.io/wp-content/uploads/2021/05/54.-Result-of-specific-weekday-function.png)
No calculation has been performed and the data and the value in the CSV file Thanks, Bernard, but I don't see how the 15 digit precision limit has any