That will probably show up as just a number and wont' be interpreted as a date. The format you want to use is:
dd/mm/yy
To apply, goto Format | Cells (or Ctrl + 1) | Number (tab), choose the format in the Date list or apply your own custom format with the format supplied above.
You can use the - sign if you want, but you need something in there.
Now this can be done, without adding any additional characters, with VBA if you like. But it would seem such a larger undertaking than just typing in a couple extra characters on entry.
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!