|Subject:||Retain Numbers as Text Format When Importing.|
|Date:||Tue, 20 Jun 2006|
I must import a text file. It contains numbers of varying formats. They
could include a colon and a period or just a colon... zeros at beginning and
I want to retain the format of the varying numbers WHEN IMPORTING a pipe
delimited text file.
How do I force Excel to import all data in the text file as TEXT. Simply
selecting format "Text" for the entire worksheet (before importing) does not
do it - that selection is overwritten.
Please test your resolution before answering.