Hi Student

For you (considering your nickname) is 14.43 hours still morning but
not for me.
So, good afternoon

Place following code in the code of your worksheet
and change the range to your needs

Private Sub Worksheet_Change(ByVal target As Range)
Range("A1:E20").Select
Selection.NumberFormat = "@"
Range("A1").Select
End Sub

Regards

Piet



Student schreef:

Good Morning!
here is the issue
I have formatted my sheet to be text but everytime I copy from a word
document the format changes to General.

is there a way that I could hard code the trigered cell to stay in Text
fromat?

please advise your help is greatly appreciated...Thank you