When I format a column with mm/dd/yy, and then type the number 070706 in
the first cell, it sees the number as the number of days that has passed
since January 1, 1900, instead of 07/07/06. Is there a way to format the
column as a date so that when I do type the 070706 in a cell is displays
as the correct date? (07/07/06) Thanks, Shelly


--
ShellyD
------------------------------------------------------------------------
ShellyD's Profile: http://www.excelforum.com/member.php...o&userid=36167
View this thread: http://www.excelforum.com/showthread...hreadid=559476