Import text files to Excel
When import text files to Excel, Column Data format by default is General format. How could I change the default setting to Text format instead. It is time consuming to change the column setting from General to Text column by column during the importing process.
I don't believe you can change the DEFAULT, but if you're always importing similar files, you can construct a macro to do the import for you.
Turn on the macro recorder and let it record as you select a file for import and run through all the settings one time, then the recorder has the code. That can be tweaked to be more versatile.
Post the resulting code here and we can help you make it a little more dynamic.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Re: Import text files to Excel
This was driving me insane for about an hour. Thanks for such a clear, concise answer!Originally Posted by JBeaucaire
My pleasure. If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
=======
NOTE: No need to "quote" previous posts, it just clutters your own thread making it harder to find the new commentary. Just use the QUICK REPLY box below. Of course, use the quote button to quote out specific things you want to discuss... Cheers.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks