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