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...
Hi Abdullah
One possible solution is to highlight the column of dates and then select Data > Text to columns > Finish
This "tricks" Excel into treating text as numbers
Alternatively copy a blank cell then highlight the dates and Paste Special > Add
This again tricks Excel into adding 0 to each cell and therefore the text gets converted to values
Thank you - so easy in hindsight (ref: text to columns above). Appreciated!