date problem--excel changing entry

D

D Blount

I want date to show as 11/05/03 and not have to enter
the / or a -. Have formatted cells to date and that but
excel ix changing to a totally different date----7/19/06?
 
D

Dave Peterson

You could use a macro that converts numeric entries to dates.

Chip Pearson has shared his:
http://www.cpearson.com/excel/DateTimeEntry.htm

Or if you're consistent (leading 0's for days and months), you could format the
column(s) as text, do your data entry and then use data|text to columns to
convert them to real dates (choose mdy as the field type).
 
Top