Solved

Excel Text To Columns - default "column data format" to Text

Posted on 2013-01-30
7
506 Views
Last Modified: 2013-02-01
In Excel Tex To Columns can I set the default "column data format" to Text?
0
Comment
Question by:Dawn7930
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
7 Comments
 
LVL 26

Expert Comment

by:redmondb
ID: 38836325
Hi, Dawn7930.

AFAIK, the only "sticky" values are those on the Delimiter page.

Would a macro help?

Thanks,
Brian.
0
 

Author Comment

by:Dawn7930
ID: 38836349
Can I set it up as a PrivateSub to run on open?
0
 
LVL 26

Accepted Solution

by:
redmondb earned 500 total points
ID: 38836572
Dawn7930,

Yes, as long as it's in the same module as your Auto_Open or Workbook_Open macros and is called by whichever of them you're using.

Regards,
Brian.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 26

Expert Comment

by:redmondb
ID: 38837371
Dawn7930,

This is a tricky issue, but unlike the rest of the English-speaking world, in Experts Exchange, "Good" means..."Not Good". To quote from one of the Help pages...
An A grade should be given if you receive the solution from the Experts; you should consider the A grade the default unless it is deficient.
...and...
It is customary to explain any grade that is not an A.

You could reasonably say that I didn't give you a solution. However if something can't be done, then "it can't be done" is a perfectly valid answer and is not grounds, by itself, for a B Grade. (The logic is that the expert has given you the correct answer and it's not fair to penalise him/her for a restriction in Excel, or whatever.)

Please do one of the following...
 - If you genuinely feel that my answers were deficient then please explain why.
 - If all the above was new to you (it is well concealed in the site) and you want to give me an A grade then please click on the Request Attention button above and ask for one of the Mod's to change the Grade. (He/she may simply "unclose" the question so you can do it yourself.)
 - If you would like clarification/confirmation of what I've said then click on the Request Attention and ask for a Mod's assistance.

I'm sorry to be such a nuisance, but B's and C's are considered to be blots on an expert's record so it's important that they're only there for valid reasons.

Many Thanks,
Brian.
0
 
LVL 26

Expert Comment

by:redmondb
ID: 38842233
Thanks, ModeIT.
0
 
LVL 26

Expert Comment

by:redmondb
ID: 38845021
Thanks, Dawn7930.
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question