Whenever I transfer a text document into excel it helpfully converts more data than it is supposed to...customer info is 3 letters and 4 numbers, and anytime this starts with 3 letters that excel thinks is a month it converts to a date. I need it to stay as a letter-number combination. I have to use the Text-To-Columns function to parse the info so I have been unable to pre-format the columns. Any ideas?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
excel treats a word as a date 1
- Thread starter dbpcar
- Start date
SkipVought
Programmer
Hi,
In Text to Columns you CAN format each "column" Skip,
metzgsk@voughtaircraft.com
In Text to Columns you CAN format each "column" Skip,
metzgsk@voughtaircraft.com
-
1
- #3
dianemarie
Instructor
Hello, when I open a .txt file in Excel I get the text import wizard. On Step 2 or 3, it allows you to choose the data format for each column (even if you parsed the data in the first or second step). Did you try that? It should work fine.
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question
- Locked
- Question