text format cells be treated as text

[parscon]

I need a Macro code for K column that all cell on this column be text format.

Please help me .

[parscon]

I found it .




Columns("K:K").Select
Selection.NumberFormat = "@"


Thank you .