title: change the date format of a column in all sheets of a workbook
body: <p>Im trying to change a custom date format to dd/mm/yyyy.
  The code below works for the current worksheet but wont work for all worksheets.</p>
  
  <pre><code>Sub dateformat()
  
      Dim ws As Worksheet
  
     For Each ws In Worksheets
          Columns("E:E").Select
          Selection.NumberFormat = "dd/mm/yyyy;@"
          'MsgBox ws.Name
      Next ws
  
  End Sub
  </code></pre>
  
  <p>its hard to manually run the macro per column as the workbook has 100+ sheets.
  any thoughts on how i can get this to work?</p>