Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
date format in excel not in line with control panel regional setti | Excel Discussion (Misc queries) | |||
Excel date field link to Word | Excel Discussion (Misc queries) | |||
Trying to make cell "date sensitive" to specific date | Excel Discussion (Misc queries) | |||
Creating a Date Selector in Excel VBA? | Excel Discussion (Misc queries) |