Format a combo box to show mmm-yyyy format
 

I have finally got (sort of) my combo box doing what I need it to do but when
I select the date-year from the list it puts it in in number format. Can
anyone assist? I can't see where there is an option for this.

Thanks in advance
--
Gai

Format a combo box to show mmm-yyyy format
 

A quick-n-dirty interim way ..

Presume you are using combo box from control toolbox

Just use an adjacent cell to point to the link cell,
eg assuming link cell is E2, place in F2: =E2+0

This converts the text number returned by the combo box in E2 into a real
number in F2, which you could then format as date to taste/point downstream
formulas to. There's probably a better/more direct way to do this, hang
around for better insights from others versed in vba.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Gai" wrote:
I have finally got (sort of) my combo box doing what I need it to do but when
I select the date-year from the list it puts it in in number format. Can
anyone assist? I can't see where there is an option for this.

Thanks in advance
--
Gai