Forum Discussion
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 type this: 10001 123 and this is what I get: 10001123.
- I type this: 5-5 and I get this: 05-May
- I type 12000929837 723200000000 and I get: 1,20009298377232E+22
I understand that I can place the apostrophe in the beginning of each value but I would be much happier if I would need to place that apostrophe in case I want that Excel would convert my number or my text.
So my question is that is there any ways I could disable this conversion feature for the whole application permanently and not only for certain cells for certain work sessions?
Thank you for all the help.
Nope, that is not possible. Either format the cells as Text before entering data, or prefix the values with an apostrophe.
Go to the File->Options-> Data, there is an "Automatic Data Conversion " part there. where you can disable all options you need.
- Created 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.
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.
Nope, that is not possible. Either format the cells as Text before entering data, or prefix the values with an apostrophe.
- Bruh, 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. - That'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?
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.
