Change Multiple Columns to TEXT Data Type

Is there a simple way to do this, without having to address each column individually?

Perhaps like this but be warned this will set all of the used range on the active sheet to text format.

Please Login or Register  to view this content.

Alf

That will mess up all my date and currency columns, though. No way to do it by calling only specific columns?

No way to do it by calling only specific columns?

Sure, try

Please Login or Register  to view this content.

Alf

I see where you're going with that; but still that's only one column. Better than a range of columns, true, but I need it to do all of the specified (read: hard-coded) columns at once. If there's a way.

Last chance

Please Login or Register  to view this content.

Alf

BOOM, that's it.

Thanks!

You are welcome.

Don't forget to mark your thread solved.

Alf

Got it, thank you.

Did an extrac check as I normally don't like using "Select" and found that the short form of the macro works just as well.

Please Login or Register  to view this content.

Alf

Nice. Is there a way to trigger that code from the toolbars, or at least without having to build in any buttons or other objects?

Yes that seems to be possible, see link for how to do so:

http://www.excel-easy.com/vba/exampl...e-toolbar.html

Alf