View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eric[_6_] Eric[_6_] is offline
external usenet poster
 
Posts: 23
Default Opening text file in excel to maintain as "text"

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