Hello again everyone, I've been trying to get some numbers imported in from a text document to show up properly and be able to be manipulated with formulae in excel.

It seems to work fine until you get to a certain number of digits then it wont recognize them as numbers anymore. For example:

961:12
1:00
452:35
38:45
947:35
3:45
5:00
373:51
157:00
2387:15
445:00
2:15
19275:13
0:27
531:37
408:54
496:11
164:04
0:30
671:15
1732:52
32:10
366:40
2525:28
1038:20
As you can see they are measurements of time, specifically in Hours and minutes, the seconds are always zero. The problem arises when you get to the numbers like that 19,000 in the middle. It doesnt recognize that like it does the others and any formulae involving a number in the tens of thousands or above is regarded as text for some reason. I've been playing with the custom number formatting trying to get it into a format that excel understands but have not been able to do so yet. Anyone have any ideas?