Another alternative is to use an adjacent cell to do the
conversion for you (this may not be acceptable). You
can use a formula thus:

=TIMEVALUE(LEFT(D5,2)&":"&RIGHT(D5,2))


where D5 contains your number.


Sorry - I initially posted this as a subthread to a
previous reply