MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Cory on July 01, 2001 9:54 AM

I ahve a combobox on a form that has time values in its dropdown list, ie: 8:00 AM, but when I select a time the cbo's format shows something like: "0.33333333". How do I change the format to display the time instead of its numerical equivalent?

Posted by Ivan F Moala on July 01, 2001 7:30 PM

ComboBox1.Text = Format(ComboBox1.Text, "hh:mm AMPM")