Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 535
  • Last Modified:

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

In Excel Tex To Columns can I set the default "column data format" to Text?
0
Dawn7930
Asked:
Dawn7930
  • 5
1 Solution
 
redmondbCommented:
Hi, Dawn7930.

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

Would a macro help?

Thanks,
Brian.
0
 
Dawn7930Author Commented:
Can I set it up as a PrivateSub to run on open?
0
 
redmondbCommented:
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
redmondbCommented:
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
 
redmondbCommented:
Thanks, ModeIT.
0
 
redmondbCommented:
Thanks, Dawn7930.
0

Featured Post

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!

  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now