?
Solved

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

Posted on 2013-01-30
7
Medium Priority
?
514 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 2000 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

764 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