Hello! I am in the process of importing data from the web to excel, however it keeps auto formatting numbers into time before presenting me with the data. I've spent hours looking around the web for a solution to that but it just doesn't exist, I can't stop it, so I'm hoping to convert everything in a new cell.

For example the returned data is:

26:38:00
24:42:00

Anything over 24 comes up like that and it is driving me insane. If I convert the cell to text I will get a number like "1.10972222222222", which is not what I want...

How can I convert this to a text valued cell with a formula in Column B to the right of the source numbers? I want the numbers to return as "26:38" and be formatted as text. Numbers under 24 read correctly as "20:16" or something, but are still formatted as Time... even when I Copy > Paste Special > Values it stays as time! I have already disabled date recognition in the macro that is importing this data but it has no effect on the time values...

Please any help would be much appreciated.