[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

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