Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm using Excel 2010 and I'm trying to edit dates in a column, but I notice that when I click in a cell, make no edits then hit enter, this strangeness occurs:

First, I click in the cell:

Click in the cell...

Then double click as if to edit...:

enter image description here

Then hit enter after no touchy poo...

enter image description here

Look at that! Now its some bizzare format I do not recognize. And wait, if I do the drop down undo button, this is what I see:

enter image description here

Does that shed any light? If it does, maybe it will help me actually successfully edit because when I do type something in there--even if it what was already there--it gives me this:

enter image description here

What exactly is going on here?

share|improve this question
    
41288 is just another format from Excel - in fact, it's "no format": Excel stores dates internally as number of days passed since 1/1/1900. Therefore, 41288 is the internal representation of 01/14/2013. Change the format back to date, as LuckySpoon suggested and it should solve the issue! –  Peter Albert Jan 18 '13 at 7:28
add comment

1 Answer

You'll most likely find that the cell isn't being formatted as a date correctly. Right click -> Format Cell choose the appropriate Date format and it should pop right back into being a date again (as Excel stores dates as numbers and then formats to suit)

Provided A29 isn't also a formula, drop the leading 0 (just for consistency, probably won't make a difference but you never know)

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.