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

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

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

Try 9/12

--

HTH

RP
(remove nothere from the email address if mailing direct)


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

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

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.


Ringo wrote:

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

--

Dave Peterson