How to stop excel converting numbers into time

Before it's said, I've already tried making the sheet as text.

I'm trying to import data from a web page, every column comes through as text except for cells that have numbers formatted like 1:28.586 which excel insists on turning that in a Custom cell for 12:01:29 AM... I don't want that!

In the import settings I have already tried selecting "Disable date recognition" but that doesn't help. All cells on the sheet are set as text before the import, and that doesn't help. Is there any other option to fix this?

Thank you.

Originally Posted by Ron Coderre

Here's a thought....
I think Excel only converts numeric data if the destination cell(s) are formatted as General or Text.
So, before importing the data, convert the destination cells to any of the non-General, non-Text formats.

Does that help?

Sadly that doesn't work. I tried with a number of different formats and they just return really long decimals.

Is there any way to just paste the scraped data as text? Such as through the macro?

Originally Posted by Ron Coderre

Can you post a small sample source file that we can import to see what you're working with?

I'm trying to import the entirety of this link and many more like it. No matter how I seem to do it, the columns of J, K & L keep coming out wrong. It pastes fine if I do it manually, but refuses to import itself cleanly.