Forum Discussion
Excel doesnot recognize the date until duble click
I have problem in Excel , I copied dates from internet report to Excel but Excel does not recognize them as date till I press double click and Enter in each cell of the date column I tried many ways...
Thank you, I had the same problem, only one trick worked.
I copied blank cell then highlight the dates and Paste Special > Add. The date changed to number format, ##### then I formatted the cells in to my preferable date format dd-mm-yyyy.
Hope this will work for everyone.
you sir are the MVP.... THANK YOU!