Cell Formatting
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 |
All times are GMT +1. The time now is 03:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com