Shelly

Are you game for some VBA?

See Chip Pearson's site.

http://www.cpearson.com/excel/DateTimeEntry.htm

Alternative...........

Start your date with an apostrophe '070706

When you have entered a great bunch of these use DataText to
ColumnsNextNextColumn Data FormatDateDMY or MDY to convert all.


Gord Dibben MS Excel MVP


On Fri, 7 Jul 2006 14:24:05 -0500, ShellyD
wrote:


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