Forum Discussion
Solved
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 ...
Nope, that is not possible. Either format the cells as Text before entering data, or prefix the values with an apostrophe.
Nope, that is not possible. Either format the cells as Text before entering data, or prefix the values with an apostrophe.
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?