vba always make column c as text format

[jimmy1986]

please help me some vba code to make range from c7 to c5000 in sheet 1 to text format. I need to keep number 0001 to number 05000 in these cells as text format everytime I put data in my table 1. I have to choose text to column every time l want to convert number to text. Any help would be appriciated

 

[Rick Rothstein]

Maybe...

Range("C7:C5000").NumberFormat = "@"