Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format date dd.mm.yyyy to dd/mm/yyyy | Excel Discussion (Misc queries) | |||
change date format from dd/mm/yyyy to mm/yyyy | Excel Discussion (Misc queries) | |||
how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel | New Users to Excel | |||
MM/DD/YYYY format Today | Excel Discussion (Misc queries) | |||
format MM:SS without mm/dd/yyyy/hh:mm:ss? | Excel Worksheet Functions |