I want my combo box to return a date format instead of a number?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using using dates in the ListFillRange in a combo box and after
selecting the date it returns the numerical value instead of the date. How do
I format the combo box for dates?

Time Period 39629 <= numerical value returned instead of date 06/30/08
 
I copied =Format(Combobox1.Value,"dd/mm/yyyy") into the colume next to the
value field but when I selected a new date it reverted back to the number
again. Am I doing this correctly?
 
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 Formatting 4
Combo Box Help 3
How to reference cell created from dropdown list in a combo box? 1
Combo Box Showing Date Selections 2
Graph linked with combo boxes 2
Number of hours between now and selected date 5
Date shows as a number 1
Combo Box 5

Back
Top