Check ou tthis link. I have used variations of this very successfully...

http://www.cpearson.com/excel/DateTimeEntry.htm
--
HTH...

Jim Thomlinson


"jdj420" wrote:

I want to know if there is a way to enter the value of a cell as (for
example) 2330 and it display as 23:30?