Date Format Macro Problem
Sub changedateformat()
Sheets("sheet1").Select 'change the sheetname here
ActiveSheet.Range("a1:a20").Select 'change here which cells
you want to format
Selection.NumberFormat = "mm/dd/yy"
End Sub
You can either call this to run from another macro or create a command
button to call this when it is clicked.
|