Opening text file in excel to maintain as "text"

Posted to microsoft.public.excel.programming

Eric[_6_]

external usenet poster

Posts: 23

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
disabling default "text to columns" while *.csv file opening	vladdraco	Setting up and Configuration of Excel	1	November 26th 08 02:00 PM
text string: "91E10" in csv file auto converts to: "9.10E+11"	[email protected]	Excel Discussion (Misc queries)	2	August 12th 08 03:13 PM
how i convert "100" to "hundred"( number to text) in excel-2007	mohanraj	Excel Worksheet Functions	1	May 11th 08 09:07 PM
Create an "import-friendly" text-file from excel?	Mikael Lindqvist	Excel Discussion (Misc queries)	3	January 9th 08 04:39 PM
.csv drops "0" when saved, even if file was set as "text".	TRminator	Excel Discussion (Misc queries)	3	November 2nd 05 02:11 PM

All times are GMT +1. The time now is 08:57 AM.

Menu

About Us