Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel date input inconsistancy
I have created a spreadsheet for data collection which is utilising
userforms for this purpose. The data is for the last financial year (06-07) and the date options in the combo box reflect this (using month only) When selected though the year changes to 07 from 06 (ie April 06 as selected becomes April 07) How can I rectify this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel date input inconsistancy
Need to see the code. Probably some place Datevalue() function is used and
wrong year was put in the function. "PhilM" wrote: I have created a spreadsheet for data collection which is utilising userforms for this purpose. The data is for the last financial year (06-07) and the date options in the combo box reflect this (using month only) When selected though the year changes to 07 from 06 (ie April 06 as selected becomes April 07) How can I rectify this? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel date input inconsistancy
Code is
ComboBox2.Value = Format(ComboBox2.Value, "mmm-yy") |
#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") |
Reply |
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 |