You're doing nothing wrong - except for Text (which bypasses XL's entry
parser), the display format has no effect on how an entry is parsed.

For a way to accomplish what you're after, see

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




In article ,
Armadillo wrote:

I have highlighted a block of cells and used format-cell-time to format for
time but when I try to type in a time using the 24 hr clock eg. 0800 it
converts the time to a date. What am I ding wrong?