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...
My solution would be to highlight range, select the find/replace and change all the - to /
cool! that works when i try to convert from text to date in a custom format of DD.MM.YYYY.
- Worked! Easy-peasy.
AlexWaterton Wyn Hopkins thank you both for responding. Given I need the amendment to the data to occur without me opening the sheet, I think I will have to create a macro and incorporate it into my sql (run via snowflake).
hopefully it will work!
thanks guys
