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.
HansVogelaar
May 19, 2021MVP
Nope, that is not possible. Either format the cells as Text before entering data, or prefix the values with an apostrophe.
- DigiA1450Sep 25, 2024Copper ContributorBruh, you have no idea what you are talking about. This absolutely can be disabled.
This is not correct.
Options > Data > Automatic Data Conversion > Disable everything.
If you don't know the correct answer, don't answer. - VSMichOct 28, 2022Copper ContributorThat's insane! On open Excel converts documents previously exported to CSV from other sources and makes them unreadable, due to this automatic conversion of numbers to Scientific format and there is no way of retrieving them (like to personal numbers used in Sweden or telephone numbers or any other longer numerical code). How were you thinking, Microsoft? Can I disable that generally in my Excel program so that doesn't happen automatically when in Excel opening documents from other programs?
- aboroczkyMay 19, 2021Copper Contributor
Hi HansVogelaar!
Thank you for prompt reply.
It is a sad day for those who wanted to like Excel but due to its stubborn behavior cannot.