| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box - format output as time
Hi All,
I created a combo box that is linked to a set of cells that contain numbers but for which I have selected to format as time i.e. the cells look like this: 12:00 AM 12:30 AM 1:00 AM 1:30 AM 2:00 AM 2:30 AM My problem is that when I select a value with the combo box, it displays them as the number, not as a formatted time and I cannot see which property to edit on the combo box to have the output formatted as time. Any help would be most appreciated! Rob :) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding Time Format | Excel Discussion (Misc queries) | |||
| Converting from time format to decimal and figuring the difference | Excel Discussion (Misc queries) | |||
| Adding time | Excel Discussion (Misc queries) | |||
| Convert decimal hour into time format? | Excel Discussion (Misc queries) | |||
| convert number to time format? | Excel Discussion (Misc queries) | |||
Threaded Mode
