Forum Discussion
Adibman
Dec 07, 2021Copper Contributor
How to Stop Excel from Translating E as Zero Digits
Hey, I have a list of codes that use a combination of numbers and letters. The problem occurs when a code contains the letter "e", in which Excel keeps changing the value after the letter "e" to zero...
JoeUser2004
Dec 07, 2021Bronze Contributor
Adibman .... If you manually enter the data ("1000+"?!), you can format the cell as Text __before__ you enter the data. Caveat: Changing the cell format after you enter the data incorrectly does not correct the data.
If you are "entering" the data from a CSV file, do not open the CSV file directly.
Instead, in Excel, __import__ the CSV file. In my version of Excel, I click Data > Get External Data > From Text. You might do it differently in your version.
Anyway, in the last dialog box of the Text Import Wizard, select the column(s) with the data and select Text under Column Data Format, then click Finish > OK.
Adibman
Dec 07, 2021Copper Contributor
I tried to import it as a CSV file and it worked. Thanks a lot