Does anyone know how to permanently uncheck that option? If you click the MS button, then "Excel Options", then ""Formulas", it is the first option in the "Working with formulas" section. This being checked makes your alpha columns display as numerals. Not a big deal until you try to copy a VLookup throughout multiple rows: It screws the reference up. I have to uncheck this box every time I open a file. Can I default this box to UNchecked somewhere?
Bookmarks