I have recently made a list with drop downs for order analysis.

I have the date price department and account for drop down titles.

I already have all the data. The dates are numerical
example(6/28/2006). When I go to my drop down menu to organize all the
purchases for a certain month all that comes up is all the dates. When
I bring the drop menu down I want the selections to be the name of the
month example(june).

Thanks


--
rbrickl
------------------------------------------------------------------------
rbrickl's Profile: http://www.excelforum.com/member.php...o&userid=35910
View this thread: http://www.excelforum.com/showthread...hreadid=557038

Format the dates in the list range as custom mmmm

OR is there more to this than I read?


Gord Dibben MS Excel MVP

On Thu, 29 Jun 2006 13:12:56 -0500, rbrickl
wrote:


I have recently made a list with drop downs for order analysis.

I have the date price department and account for drop down titles.

I already have all the data. The dates are numerical
example(6/28/2006). When I go to my drop down menu to organize all the
purchases for a certain month all that comes up is all the dates. When
I bring the drop menu down I want the selections to be the name of the
month example(june).

Thanks

Yah there is a little more to it. See Attachment for details about how
the dates show up in the drop down menu.


+-------------------------------------------------------------------+
|Filename: Date.doc |
|Download: http://www.excelforum.com/attachment.php?postid=4958 |
+-------------------------------------------------------------------+

--
rbrickl
------------------------------------------------------------------------
rbrickl's Profile: http://www.excelforum.com/member.php...o&userid=35910
View this thread: http://www.excelforum.com/showthread...hreadid=557038

I'm not about to start chasing around to other sites when you could add to your
description and post here.


Gord

On Thu, 29 Jun 2006 14:28:13 -0500, rbrickl
wrote:


Yah there is a little more to it. See Attachment for details about how
the dates show up in the drop down menu.


+-------------------------------------------------------------------+
|Filename: Date.doc |
|Download: http://www.excelforum.com/attachment.php?postid=4958 |
+-------------------------------------------------------------------+

Sorry. Here is the same thing again. // Stands for the bring down
function.

Date // Account // Price // Department //

6/12/2006 B3433 487.99 Frank
6/13/2006 B3433 432.99 Gregory
6/14/2006 C2354 325.34 Frank
6/23/2006 C2322 3423.23 Frank
7/12/2006 B3433 43.33 Harvy
7/23/2006 B3433 4335.32 Tammy
8/23/2006 C2342 324.34 Harvy




Date has bring down box that says:

(All)
(Top 10)
(Custom)
6/12/2006
6/13/2006
6/14/2006
6/23/2006
7/12/2006
7/23/2006
8/23/2006

I want it to say:

(All)
(Top 10)
(Custom)
June
July
August

With the same dates still in the table like now.


--
rbrickl
------------------------------------------------------------------------
rbrickl's Profile: http://www.excelforum.com/member.php...o&userid=35910
View this thread: http://www.excelforum.com/showthread...hreadid=557038

From your description, it seems you did not create the drop-down menu, you
simply have Autofilter turned on.

Autofilter list will show exactly what is in the cells.

You cannot change this AFAIK

You can use the Custom to extract only the month you wish to see.


Gord

On Thu, 29 Jun 2006 16:12:41 -0500, rbrickl
wrote:


Sorry. Here is the same thing again. // Stands for the bring down
function.

Date // Account // Price // Department //

6/12/2006 B3433 487.99 Frank
6/13/2006 B3433 432.99 Gregory
6/14/2006 C2354 325.34 Frank
6/23/2006 C2322 3423.23 Frank
7/12/2006 B3433 43.33 Harvy
7/23/2006 B3433 4335.32 Tammy
8/23/2006 C2342 324.34 Harvy




Date has bring down box that says:

(All)
(Top 10)
(Custom)
6/12/2006
6/13/2006
6/14/2006
6/23/2006
7/12/2006
7/23/2006
8/23/2006

I want it to say:

(All)
(Top 10)
(Custom)
June
July
August

With the same dates still in the table like now.

Hi

I think the only way to achieve what you want would be to insert a new
column A.
In cell A2 enter =B2 and FormatCellNumberCustommmm
Copy down column A for the extent of your data.
Extend your Autofilter range to include the newly inserted column A.
Use the dropdown on column A to Select the Month required.

--
Regards

Roger Govier


"rbrickl" wrote
in message ...

Sorry. Here is the same thing again. // Stands for the bring down
function.

Date // Account // Price // Department //

6/12/2006 B3433 487.99 Frank
6/13/2006 B3433 432.99 Gregory
6/14/2006 C2354 325.34 Frank
6/23/2006 C2322 3423.23 Frank
7/12/2006 B3433 43.33 Harvy
7/23/2006 B3433 4335.32 Tammy
8/23/2006 C2342 324.34 Harvy




Date has bring down box that says:

(All)
(Top 10)
(Custom)
6/12/2006
6/13/2006
6/14/2006
6/23/2006
7/12/2006
7/23/2006
8/23/2006

I want it to say:

(All)
(Top 10)
(Custom)
June
July
August

With the same dates still in the table like now.


--
rbrickl
------------------------------------------------------------------------
rbrickl's Profile:
http://www.excelforum.com/member.php...o&userid=35910
View this thread:
http://www.excelforum.com/showthread...hreadid=557038