| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Entering dates in vba inputbox as ddmmyy. Excel returns mmddyy
I am using an inputbox in VBA to return a date into an excel cell. When I
enter the date as dd mm yy, excel returns it as mm dd yy, irrespective of how I have formatted the receiving cell. It only applies to the lower numbers such as 06/07/05. If I were to enter 25/07/05, it would return correctly. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I change MMDDYY to YYYYMMDD? | Excel Discussion (Misc queries) | |||
| Convert mm/dd/yyyy to mmddyy | Excel Discussion (Misc queries) | |||
| how do i format date to DDMMYY | Excel Discussion (Misc queries) | |||
| Entering DATEs in EXCEL should not require use of "/" slashes. | Excel Discussion (Misc queries) | |||
| Entering dates in Excel 2002 | Excel Discussion (Misc queries) | |||
Threaded Mode
