Drop down box issue

K

Kevin G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
Drop down list control value in vba 2
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
Pick from drop-down list gives empty or erroneous result 6
Using a drop-down box to sort data based on seperate columns 2
ASK Field Formatting 1
How to use check boxes with drop down menues 0
Insert new row with drop-down box but problem with cell linkreferring to the original drop-down box 2

Top