|Subject:||RE: Retain Numbers as Text Format When Importing.|
|Posted by:||tim m|
|Date:||Tue, 20 Jun 2006|
The last step before 'finish' in the import wizard has an area top, right
that says column data format and allows you to force columns to be imported
> 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
> end, etc.
> 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.
Retain Numbers as Text Format When Importing. posted by xardoz on Tue, 20 Jun 2006