If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
frustrated excel newbie
I am trying to make a monthly worksheet. I did get a drop down box set up,
typed 6/1/2010 through 6/31/2010 in an empty column, used the validation tab, chose list and highlited the dates column which showed up as a formula in the validation window under my "list: choice. problem is, when I click on one of the dates I get a serial number, I am guessing that is what it is and no date??? Been at it for 3 hours trying different ways.what am I doing wrong here??? TJ |
#2
|
|||
|
|||
frustrated excel newbie
The first thing you are doing wrong is not telling us what you want to do.
What are you using the drop down box for (why use it at all?), what are you trying to do, and what solution are you looking for? As an aside, 6/31/2010 is not a valid date. Is this your problem? Regards, Fred "TJ" wrote in message ... I am trying to make a monthly worksheet. I did get a drop down box set up, typed 6/1/2010 through 6/31/2010 in an empty column, used the validation tab, chose list and highlited the dates column which showed up as a formula in the validation window under my "list: choice. problem is, when I click on one of the dates I get a serial number, I am guessing that is what it is and no date??? Been at it for 3 hours trying different ways.what am I doing wrong here??? TJ |
#3
|
|||
|
|||
frustrated excel newbie
Format (press Ctrl+1, and look in the Number tab) your input cell to display
the Date "mm/dd/yyyy" rather than the serial number. "TJ" wrote in message ... I am trying to make a monthly worksheet. I did get a drop down box set up, typed 6/1/2010 through 6/31/2010 in an empty column, used the validation tab, chose list and highlited the dates column which showed up as a formula in the validation window under my "list: choice. problem is, when I click on one of the dates I get a serial number, I am guessing that is what it is and no date??? Been at it for 3 hours trying different ways.what am I doing wrong here??? TJ |
Thread Tools | |
Display Modes | |
|
|