A alexseys Dec 11, 2009 #1 is there a way to tell excel when opening new file, treat is as text? i.e. even if there is a 00000 value leave it the way it is
is there a way to tell excel when opening new file, treat is as text? i.e. even if there is a 00000 value leave it the way it is
G Gord Dibben Dec 12, 2009 #2 New workbooks don't have values. Do you mean open a *.txt file in Excel and have values treated as Text. Open the *.txt file and the Text Import Wizard will pop up. In Step 3 select all columns(Shift + click).......Column Data Format>Text. Finish. Gord Dibben MS Excel MVP
New workbooks don't have values. Do you mean open a *.txt file in Excel and have values treated as Text. Open the *.txt file and the Text Import Wizard will pop up. In Step 3 select all columns(Shift + click).......Column Data Format>Text. Finish. Gord Dibben MS Excel MVP
