View original (French)

Date format not recognized

Solved
Luc -  
 Corinne -
Hello,

After several hours of research, I can't find an answer to my problem... Sorry if the question has already been asked.
After extracting data from EBP, the column containing dates is not recognized as such; no matter how much I change the format, it doesn't make a difference.
The only solution is to go into each cell and press the "Enter" key; the format is then recognized...
But the number of rows to process is too large...

Any suggestions?

Thanks!

3 answers

  1.
    gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 744
     
    Hello,

    You take an empty cell outside the range and enter 1.
    You copy your cell with 1 and select your stubborn dates, then right-click / paste special and choose multiplication.
    This should convert them to dates because you likely have a trailing character, space, or apostrophe for example.
    --
    Always zen
    Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away. Antoine de Saint-Exupéry
    60
    1. seb
       
      Thank you for the tip.
      0
    2. John1000
       
      If I had discovered this trick at the time of posting this comment, I would have surely saved 2 months of my life.
      5
    3. Labeye
       

      You are amazing! I'm less patient, I only waited 2 hours and I don't regret it! Thank you for the tip! Have a good day

      0
    4. StL
       

      Wow Thank you !!!!!

      0
    5. Corinne
       

      Thank you!

      0