Thanks, Glenn

I can see that what you did have solved the problem on Col B. The question is, how can I fix the format of col A?