| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel date input inconsistancy
This is not a combobox problem, it is your format statement. The same
problem would occur with mydate = "06-07" mydate = Format(mydate, "mmm-yy") The problem is with the "mmm". Change to "mm". Also note the months are first and the year is second. "PhilM" wrote: Code is ComboBox2.Value = Format(ComboBox2.Value, "mmm-yy") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002: How to overcome inconsistancy in auto cell function ? | Excel Discussion (Misc queries) | |||
| Can excel have a button to input (stamp) the systems date and/or . | Excel Worksheet Functions | |||
| Excel date input inconsistancy | Excel Discussion (Misc queries) | |||
| Iteration inconsistancy | Excel Discussion (Misc queries) | |||
| excel input date format | Excel Programming | |||
Threaded Mode
