How do I change a date format 3/14/2006 to 3-14-2006 in Excel 2002
 

How do I change a date format 3/14/2006 to 3-14-2006 in Excel 2002
 

Format/cells/custom

choose dd-mmm-yy

---Glenn


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=522844

How do I change a date format 3/14/2006 to 3-14-2006 in Excel 2002
 

Sorry, hit send too fast. You need to adjust the dd-mmm-yy format, just
edit it in the custom box to remove one of the "m"s.

---Glenn


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=522844