Prevent Excel from converting times into floats

I have imported tabulated data from a website using Excel's "Data > From Web". The problem is, that a time, e.g. 47:38:00, is automatically translated. If I click on it, 01/01/1900 23:38:00 is shown in the formula textbox, and converting the data to text or general converts it to a float, 1.984722222.

The float conversion is super annoying as this is what is presented when extracting data from the spreadsheet. Is there a way to stop Excel from manipulating the data, and just treat everything as raw?

Recent Questions...