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")