How do I insert Numbered dates in Microsoft Excel 2003?

I enter the date 3/15, and when I exit the cell, it automatically changes to 15-Mar. I just want 3/15. Any tips? (It does the same when I enter 3-15)How do I insert Numbered dates in Microsoft Excel 2003?
right click on the cell you want the date in and format cell and pick the date format you would like to useHow do I insert Numbered dates in Microsoft Excel 2003?
Custom format m/d


As I'm is Australia I have to enter the day then the month but your regional settings should take care of input variations.