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

--
__________________________________
HTH

Bob

"Pyrite" wrote in message
...
Hi,

I have a column for enginners to enter the time an appointment starts. I
want this column to look like 10:00, 12:00, 14:00 and so on. Not those
exact
numbers, just that format. I went to format cells and all the time formats
include seconds or dates so I went to custom formats. On here I found
hh:mm
which is exactly what I need. The only problem is that if I simply enter
10
for instance meaning 10am (as many engineers will) for some reason the
time
remains at 00:00 and a date is added before it, usually a date in Jan
1900.
Is there anyway of forcing it to only format to hh:mm?