Time

[Greg Brow]

I am hopeless today just cant seem to get the cell to read in 24 hour time.
if i type in 2030
it will show the date and 1200.am

How can I fix this I have tried the custom controls, just cant work it out

Thanks

Greg

 

[R.VENKATARAMAN]

not clear. however try typing
20:30 ---note the colon
and fromat as time-13:30
mine excel 2000

 

[Greg Brow]

Thankyou will now post in the beginners forum. I just could not think of
that.

Greg