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

Hi, Dawn7930.

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

Would a macro help?

Thanks,
Brian.

Can I set it up as a PrivateSub to run on open?

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.

Thanks, ModeIT.

Thanks, Dawn7930.