You need the colon, 08:00

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Armadillo" wrote in message
...
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?