Entering Time as HHMM; having it converted to HH:MM

Thanks arlu, I have done that here: http://www.excelforum.com/excel-gene...-to-hh-mm.html

Try this,
suppose you are entering time as 1130 in cell A1
now in A2(or wherever you want it as 11:30) enter this formula
=LEFT(A1,2)&":"&RIGHT(A1,2)
then format this cell as Custom and type [h]:mm