Key in Date and time

[Tylim]

How can i code the fields with mm/dd/yyyy hh:mm. so that when i key in i
just key in numbers don have to worried about the the slashes and colon.
Thanks.

 

[Peo Sjoblom]

You need code for that

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

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey