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