I have exported a report into Excel from a suppliers website.

It now includes a * infront the date format which is not displayed. I cannot remove it, the data displays a date as normal but is seens as text in the cell.

If I use the "Edit Replace" function it removes all the data and I can't find any other way to remove it. I think the spreadsheet thinks is a wildcard.