Forum Discussion

Abdullah Omam's avatar
Abdullah Omam
Copper Contributor
Jan 04, 2017

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...
excel
Formulas and Functions
Wyn Hopkins's avatar
Wyn Hopkins
MVP
Jan 05, 2017

are you able to attach a file containing the problematic column?

  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Jan 05, 2017

    Sorry Abdullah, I missed that file

     

     

    SergeiBaklan's answer may be the key

     

     

    • Abdullah Omam's avatar
      Abdullah Omam
      Copper Contributor
      Jan 08, 2017

      so , is there any way to solve the issue ?

      • Amgad_Ali2400's avatar
        Amgad_Ali2400
        Copper Contributor
        Nov 25, 2023
        Did you reach a solution ?
        I didn't solve it yet.

Resources