|You will need to use a Custom Format|
Right click on the cell with your Date
Select Format Cells
Select Custom, at the bottom of the popup window
In the small input box, under the word Type:
delete what ever is in the box and enter:
As long as your cell contained an actual date then you should see it change.