Data entry for returning time

N

Nonie

Hi there,

I have the cell formatted for time. I want to type 2043 to have excel
return 20:43. In other words, I don't want to have to type the ":"

Is there a way to do this?

Thanks!
 
Top