This works beautifully thanks.


"Anne Troy" wrote in message
news:c746b$42d91f08$97c5108d$25666@allthenewsgroup s.com...
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