Combo Box Format

  • Thread starter Thread starter Charlie
  • Start date Start date
C

Charlie

Take a look at this article in PC magazine. It explains
Combo box's and also an in cell alternative.

http://www.pcmag.com/article2/0,4149,1207112,00.asp

Charlie O'Neill
-----Original Message-----
Created a combo box in Excel which refers to a list in
Click to expand...
another worksheet.The list is in Date format (22-Mar-
04).The dropdown list shows the Date format,but as soon as
I choose the required date,the format changes to
general,giving me a value of "38798". How can I fix it?
 
You must log in or register to reply here.

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

Combo box displays positions not date 2
How do I create a combo box that is tied to another combo box? 2
Combo box date format problem 5
Formatting combo box drop-down list 1
keep date format in a Combo box 1
Combo Box format 0
Date format in a combo box 1
Format Dates in Control Combo Box 3

Back
Top