Thread: Time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg Brow Greg Brow is offline
external usenet poster
 
Posts: 29
Default 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