Hi Folks,

I have a question.

When I 'Text to Columns' the string '04/19 07:26 04/19 07:28' (which
contains dates in MM/DD format), it converts the date to '1/04/2019'.

Is there any way to stop excel from converting the date?

Thanks for your help.

Doug.