X
xardoz
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!
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!