number as string with importing txt file
 

How to keep the left zero(s) of a string in a cell by importing a simple
text file ?
thank you in advance
GH

number as string with importing txt file
 

Tell the text import wizard to format the column as text.
--
David Biddulph

"alfred wallace" wrote in message
...
How to keep the left zero(s) of a string in a cell by importing a simple
text file ?
thank you in advance
GH

number as string with importing txt file
 

Don't import the *.txt file.

Open it directly from FileOpen.

The Text to Column Wizard will appear and let you choose the formatting of the
data as Text


Gord Dibben MS Excel MVP

On Wed, 16 Apr 2008 22:54:00 +0200, "alfred wallace" wrote:

How to keep the left zero(s) of a string in a cell by importing a simple
text file ?
thank you in advance
GH