Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
frustrated excel newbie | Excel Worksheet Functions | |||
So frustrated! Please help! | Excel Discussion (Misc queries) | |||
Frustrated | New Users to Excel | |||
Real Newbie newbie question | New Users to Excel | |||
Number stored as text: Frustrated with Excel-Word Merge | Excel Discussion (Misc queries) |