My cells are set to text format but when I find and replace numbers in them they automatically change themselves to date format even though I don't want that. How do I globally disable automatic formatting in Excel?
21 Answer
The workaround for this would be to put an apostrophe (') in front of your "Replace with:" value. Just one more keystroke.
BTW: Microsoft indicates that in Excel 2013, using the TEXT format will stop it from auto-converting numbers to dates. support.office.com: Stop automatically changing numbers to dates
1
