Ms. Compy Fix-it – Dates Converting to Numbers

Hello again!
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!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s