KeepITcool,

I am not doing it in "manual" wizard I am doing this
in "macro" so, what is the command in macro that will
maintain the text column as a text when I open it in excel?

-----Original Message-----
in step3 of the text to column wizard,
define the column as text, not general


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Eric" wrote:

Hi There,

I am writing a macro on how to open a text file in
excel
in such as way that my file maintain a "number" text as
a
text. Please see below for an example:

I want to open this in column as a text NOT a number.

Code IDNO Region
0001 12345 N1234
0002 35353 C3535
.
.
so on.

How do I do that?

Thanks in advance for your help.
Eric



.