Date And Time Entry
http://www.cpearson.com/excel/DateTimeEntry.htm

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"vodoris" wrote in message ...
i want to enter a date by only using number keys but i want the outcome to
have the slashes in it i.e. 060204 -- 06/02/04. just like if you enter a
currency like 602.04 it comes out like $602.04 and you don't have to add the
$ because of how the cell is formatted.