I have created a userform that populates an excel sheet, however, for every combo box I have that either contains a date or time drop down box once you select i think it produces the atomic clock or general number. This is also the number that is then transfered to the sheet

I have tried to format the columns in date and also time format but nothing seems to work. Any help would eb great.

thanks in advance