Hello,

I have had this problem for years and hopefully there will be an answer.

I am trying to open a *.mht (web archive?) page with lots of columns of data. Some of the data in the web page is like this "13-2" or "9-4" e.g. colon separated numbers.

And yet it imports the data like this "13-feb" or "09-apr".

I want to retain the original data and not have excel convert it to dates - I have tried everything I know and searched archive articles here, but cannot stop excel doing this...!!!