I am importing a pipe delimited text file into Excel 2003.

One column contains numbers that may be formatted in various ways. A number
may contain a combinations of a colon and a decimal. Or, it may contain only
a colon. A number may have a zero at the beginning or end of the number.

28:08.92
92:00
08:40

Excel automatically changes the formatting of this column and produces
incorrect results. It strips zeros, rounds up, displays as "time", etc.
Examples:

Text File Displays.....Excel Changes To
"08:12.07"..............08:12.1
"04:00"..................4:00
"92:00"..................92:00:00

Attempting to manually format this column after data has been imported is
not successful. I have been unable to define a format that covers the
various formats that may exist.

How do I import this pipe delimited text file into an Excel worksheet and
maintain the correct format of the numbers shown above?

Thanks!