Hi,
Can anyone help me with this problem?

I have a column of data with mixture of text and number.
I want to convert the whole row to text instead to mixture.

I know in excel, to make a number to a text you have to add a ' infront of the number.

Secondly in a particular worksheet, how to i write a code to change the whole activecell data to convert to text?



Can anyone help me?


Thank alot