Dave Peterson wrote:
Did you remove the linkedcell/controlsource?

It works, it leaves the date format in the combobox alone, but with the
controlsource removed, how do i get the value in the combobox in the
cell where I need it(AL1) ?

matt