Convert Excel cells stored as text to date and number coming from notepad

Hi arthurbr,

OK that will work, but I need to solve the problem with VBA code.
Coverting what you suggested into code won't work unfortunately.

Thanks for your reply !