You can't do this by a formula - you should select the cell and use
Format | Cells | Number (tab) then Custom and either scroll down until
you find a format you want or in the panel type mm/dd/yyyy.

Hope this helps.

Pete