Forum Discussion
aboroczky
May 19, 2021Copper Contributor
Disable all automatic conversion in Excel
Hello Everyone! I would like to disable all the automatic conversions in Excel. What I mean is that if I type in something I would like that it would look exactly how I typed it. Examples: I ...
- May 19, 2021
Nope, that is not possible. Either format the cells as Text before entering data, or prefix the values with an apostrophe.
Irina_B
Feb 06, 2024Copper Contributor
Go to the File->Options-> Data, there is an "Automatic Data Conversion " part there. where you can disable all options you need.
- DigiA1450Sep 25, 2024Copper ContributorCreated a micro$oft account just to tell you thank you!!!! and that your answer is correct and to tell HansVogelaar he doesn't know what tf he is talking about and to get out of this message board.
- HansVogelaarSep 26, 2024MVP
Calm down, guys. This discussion started in 2021. At that time, the Disable Automatic Conversions option had not been added yet. It was introduced much later.
- SergeiBaklanFeb 06, 2024MVP