Make long numbers that aren't number stop being exponents

[GracieAllen]

Excel 2019.



I have a couple applications that create .csv files when exporting. There is ABSOLUTELY NO control over how they export or what they export. They just dump everything. Including very long library card "numbers" and very long credit card "numbers" which Excel does bad things to.

They show up looking like this: 1.1011E+12. This column that contains email addresses, names, house addresses, other clearly text fields. AND THESE scientific notations. I've TRIED formatting the column, telling Excel the column is text. That doesn't work. I've tried telling the it the column is a number with zero decimal places. That makes the junk a long number, but the number is no longer accurate. It started as 16 digits ending with something like 2193 and ended with a 2190 or originally ended in 0237 and is now 0230. I don't KNOW if other digits in the string are correct or not, but I KNOW the last digit keeps getting changed.

HOW do I make Excel STOP this?