I'm unsure if this is the correct place for this. I do think that what I'm trying to accomplish will require a macro. Essentially I would like to type "2300" in a cell and have it display time as 23:00. When I do this, it thinks its a date and displays "4/18/1906 12:00:00 AM". I would like to avoid the need to put a colon in between the hours and minutes. If anyone can give me any insight as to how to approach this it would be greatly appreciated.