I have a combobox in a userform that selects a time. The issue is whe
you select a time, it shows up as a serial time and not in a #:#
format. I don't see anything in the properties that seems to addres
this. How do you set the numbering format of a combobox

--
cmk1
-----------------------------------------------------------------------
cmk18's Profile: http://www.excelforum.com/member.php...nfo&userid=604
View this thread: http://www.excelforum.com/showthread.php?threadid=39722

Format
Cell
DATE


"cmk18" wrote:


I have a combobox in a userform that selects a time. The issue is when
you select a time, it shows up as a serial time and not in a #:##
format. I don't see anything in the properties that seems to address
this. How do you set the numbering format of a combobox?


--
cmk18
------------------------------------------------------------------------
cmk18's Profile: http://www.excelforum.com/member.php...fo&userid=6047
View this thread: http://www.excelforum.com/showthread...hreadid=397225

See suggested answer.

--
Regards,
Tom Ogilvy

"cmk18" wrote in
message ...

I have a combobox in a userform that selects a time. The issue is when
you select a time, it shows up as a serial time and not in a #:##
format. I don't see anything in the properties that seems to address
this. How do you set the numbering format of a combobox?


--
cmk18
------------------------------------------------------------------------
cmk18's Profile:
http://www.excelforum.com/member.php...fo&userid=6047
View this thread: http://www.excelforum.com/showthread...hreadid=397225