Excel keeps converting my product codes with E to scientific notation. How do I stop this permanently?

I have a column of product codes that include letters and numbers, like 4E75, 2E100, 8E22. Every time I paste new data into this column, Excel automatically converts these codes into scientific notation (4E+75, 2E+100, etc.) and I lose the original text format. I have tried formatting the column as Text before pasting. I have also tried using the import wizard and setting the column as Text there. The problem happens again every time I open a new CSV or paste from another source. Is there a way to tell Excel to never interpret E as scientific notation globally or at least for a specific workbook? I am using Excel 365 on Windows. I know about the option to disable automatic data conversion in File > Options > Data, but I want to know if that actually works reliably for other people before I change it.