Date format not recognized Solved

Question

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!

gbinforme · Accepted Answer

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

Vaucluse · Answer

Hello
without the template, how can we respond to you accurately?
At least tell us what the display contains in the cell or cells to be processed!
However, still try this "trick" that sometimes helps resolve this data transfer issue:

copy an empty cell
select the date field
right-click / paste special / and "add"

looking forward to hearing from you, if needed
best regards

--
The quality of the response primarily depends on the clarity of the question, thank you!

Luc · Answer

Thank you very much for your quick responses. After quite a bit of tinkering, I ended up multiplying my dates by 1, which solved my problem.  Thank you!!

Date format not recognized

3 réponses

Windows spotlight is not working.

Samsung j5 unable to answer

Scam of the suvedene highway

Remove 360 antivirus

My pc's screen is flickering.

Wearline: what do you think?

Eko tank smartwatch

Ibiza sound reviews

Only one of my iphone headphones works. what to do?

Mb to mb conversion and difference.