RE: Retain Numbers as Text Format When Importing.

Giganews Newsgroups
Subject: RE: Retain Numbers as Text Format When Importing.
Posted by:  xardoz
Date: Tue, 20 Jun 2006

Resolved.  Select Text for the column when importing instead of assigning
format "Text" to the entire worksheet.

"xardoz" wrote:

> 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.

Replies

None

In response to

Retain Numbers as Text Format When Importing. posted by xardoz on Tue, 20 Jun 2006