Kweenie
12/12/2006 2:39:00 PM
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