How do make input date by "month/day" in Excel?

R

Ringo

I want to input the date 9-Dec by "12/9" in Excel, however it shows 12-Sep.
Please help to solve this problem.
 
D

Dave Peterson

Or you could change your windows short date to look more like mm/dd/yyyy.

But this will affect other programs, too.

You can change this setting by going to the Windows control panel
regional settings
click the customize button on the "regiona options" tab
modify the short date format on the Date Tab.
 
Top