Time
 

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

Time
 

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

Greg Brow wrote in message
...
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

Time
 

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

Greg
"R.VENKATARAMAN" $$$ wrote in message
...
not clear. however try typing
20:30 ---note the colon
and fromat as time-13:30
mine excel 2000

Greg Brow wrote in message
...
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