Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop down box issue
I have a drop down box that when an item is selected it
populates a cell with the data. The issue I'm having is that the different items within the drop down choices are of different data types. Is there anyway to keep the data type "absolute" to the choice rather than what the cell is formatted to? The specific problem I'm having is when I select a time choice in the drop down, it populates the cell with a decimal number (ie: 19:00 = .875). Any help would be appreciated. Thanks (again), Kevin G |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down box issue | Excel Worksheet Functions | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
drop down list issue | Excel Discussion (Misc queries) | |||
Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions |