Hello Jeff,

There are 2 ways to change the cell format. Manually or through code.
The manual method involves selecting the cell going to the menu bar and
selecting: Format || Cells... || Number (tab) . Under Category select
Date. You will see a list of predefined date formats.

The second way is through code. Say the cell in question is A1.
*Range("A1").NumberFormat = "mm/dd"*
This overides all other format conditions. You can also apply this to
multiple cells...
Range("A1:C10").NumberFormat = "mm/dd"

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=495605