Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions |