Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Combo Box Formatting problem
hello all,
I am trying to take a list of times (starting with 12:00 AM, 12:15 AM, 12:30 AM, etc. all the way to 11:45 PM) in one sheet and populate a combo box in another sheet with these times for time entry. That part I can handle. However, when I click the box and transfer the value of the combo box to the designated cell, I can't seem to format the resultant decimal number (i.e. 0.62500002 for 3:00 PM) as a time. I suspect that the problem lies with the fact that I can't seem to change the data type of the combo box. It looks like it is a string and the resultant number is actually a string. One final observation before I pose the relevant questions: If I click the combo box and get a value in the designated cell and then click that cell and click into the 'formula edit bar' of the cell (where you would edit a formula), as soon as I click out of the cell, it changes to the desired format (3:00 PM). So here are the questions: 1. Is there a way to change the data type of the combo box? 2. Is there a work around to this problem besides trying to change the data type? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo box problem | Excel Discussion (Misc queries) | |||
Combo box problem | Excel Discussion (Misc queries) | |||
Simple combo box problem | Excel Discussion (Misc queries) | |||
combo box problem in Excel | Excel Discussion (Misc queries) | |||
Combo Box problem | Excel Discussion (Misc queries) |