Try this, Rob:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=75
*******************
~Anne Troy

www.OfficeArticles.com


"Rob" wrote in message
...
I was wondering if there is a way to be able to type in 4 number eg 1245
and
the cell to automatically format this to hh:mm ie 12:45.

many thanks,

Rob