View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Alphie Alphie is offline
external usenet poster
 
Posts: 1
Default How do I enter mins and secs in Excel without using caps/colon

Using Excell, I need to fill columns with minutes and seconds (ie 10:22).
Having to use caps and colon to insert the colon between the minute and
seconds is time consuming, is there any way round this anybody please?