title: Error with Format function
body: <p>I am having a problem with the Format() function in excel vba. I am trying to alter the formatting of a date formatted cell to change the way it is displayed. However, everytime i invoke Format to do that i get the error: "Compile Error: Wrong number of arguments or invalid property assignment."</p>
  
  <p>here is the code:</p>
  
  <pre><code>Sub test()
       Dim given
       given = DateSerial(2012, 10, 11)
       dateformat = Format(given, "dd/mm/yy")
       MsgBox given &amp; vbCrLf &amp; dateformat
  
   End Sub
  </code></pre>
  
  <p>This is just a test function and should function on its own and return "11/10/12". This code works on other computers. What could be wrong?</p>