I'd start at Chip Pearson's site:
http://cpearson.com/excel/DateTimeEntry.htm



Brad wrote:

Using 2007 (but need compatibility with 2003)

I want the "look" at what was entered - if the date contains "slashes" leave
it alone - if not, add the slashes. My main concern is to know what is the
"format" in data entered (regardless on how the cell is formatted) - I can
add the slashes as needed.

--

Dave Peterson