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

Hi Marcol,

No, in the spreadsheet I have, you enter the time as a 4 digit text string, and then the same cell that you entered the time in displays the time as HH:MM.

See attached. (Using Active X?)

Time.xlsm