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.
SergeiBaklan
Feb 06, 2024MVP