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:
Then double click as if to edit...:
Then hit enter after no touchy poo...
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:
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:
What exactly is going on here?