Setting a column to Text datatype
 

I'm sure this is deathly simple but for whatever reason, I can't seem
to discover (either on my own or through other Google posts) how to set
an entire column to the Text datatype through VB6.
Any help would be appreciated.

Setting a column to Text datatype
 

one way:

ActiveSheet.Columns(1).Cells.NumberFormat = "@"


In article .com,
wrote:

I'm sure this is deathly simple but for whatever reason, I can't seem
to discover (either on my own or through other Google posts) how to set
an entire column to the Text datatype through VB6.
Any help would be appreciated.