hi Asu

assuming that the 2130 is on the C8

=abs(left(c8,2)&":"&(right(c8,2))

format as 13:30:55

hope this helps
regards from Brazil
Marcelo

"ASU" escreveu:

Need help on this one. How do I format a textbox, embeded in a userform, so
that when I type the hour 2130 it displays 21:30.
--
ASU