Today I encountered a really annoying problem in Excel. In switching between open files, suddenly some of my dates were converted to numbers. September 3rd, 2014, became 41885, and all my columns expanded. I knew I’d hit something by accident, but no amount of Undo would fix it, and even changing the column’s Number Format to Date didn’t make them appear as dates!
Turns out, I had accidentally hit Ctrl + ` instead of Ctrl + Tab to shift between open Excel files. This turns on Show Formulas! So simple, yet it took me a good few minutes to figure it out. So if you’ve searched for this issue and found this post, Ms. Compy Fix-it is here to tell you you’re not alone!
So, if you find your columns unexpectedly expanding, and weird things happening to your data, check to make sure you haven’t accidentally turned on Show Formulas!