Dateformat in combobox

Hello,

I have a column with date and time that I fill to a combobox. Why does the date does not shown as in the column? See Picture

Please help!

Cheers RaffeDateComboBox.jpg

Here it comes. Raffe

Try to change cells format to "yyyy.mm.dd hh:mm:ss", because current format is "yyyy.mm.dd hh:mm:ss.0"

Thanks for the replay kasan, I tried, the same result.

I would like to have the format becuase I would like to show ms in my graph.

Thanks Norie! It works in my example, but how do I change if my row is on another sheet?

Thanks Norie! A lst question, if I would like to have a decimal (,) instead of dot (.) what do I change?

I tried that but it did not work. The combobox did not fill at all.

Thanks again!