convert standard number to time format

[TEA]

I have a customer that whats to be able to enter time as military time 2123
w/no colons and it would be converted to a normal time format 9:23 PM

 

[T. Valko]

See this:

http://cpearson.com/excel/DateTimeEntry.htm

Biff