Text in excel.
Posted by James on January 31, 2000 2:31 PM
Is there a way to force excel to leave text values alone when opening a text file that was created in another program? As it stands it converts "0:0 1/4" to a date when it is just text representing a length. The files are tab delimited and have lots of columns in them. Some of with are values like the above that excel messes with if you just open it. You can go through the wizard and make all columns "text" in stead of "general" but is there a switch that makes that automatically the default column format?
Thanks for any help.