How do I completely turn off Excel 2010 autoformatting?
- by Samuel
I am using a lot of csv files at work with excel 2010. These have no formatting so Excel 2010 autoformats all the cells. I've found workarounds but the ones I have found require action for each file or each cell (i.e. adding a single quote).
My current workaround is using the "show formulas" option under formula auditing in the formulas tab. This…