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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"JCJimmie" wrote in message ...
|I need a macro/vbs/directions on:
|
| In a cell, entering 2345 and having it displayed as :23.45, or entering
| 12345 and having it displayed as 1:23.45 ... As a swimming coach I would find
| this a great help.
|
| Thanks for the insight...
|
| JCJ