Do I need to format the textbox for time?
--
hol


"hol" wrote:

I am using a vb code that when entering hours and minutes it adds colon
between the hours and minutes. ie if I enter 105 it gives 1:05.
The code is working find for some cells, but every now and then it throws a
track!

For instance the above example it gives me 2520:00 instead of 1:05.
Any ideas?????

--
hol